I am attaching my dashboard , one of the chart I have is portfolio vs segment, segment is what I select from the slicer and the chart shows portfolio and selected segment approval rate on the chart which you can see with green and yellow lines. I am wondering if it is possible when any slicer filter is selected the yellow line labels show that it is that particular segment is selected vs portfolio label and when no slicer filter is selected it only shows the portfolio labels.
Is it possible, please advise.
Also the portfolio vs segment chart, portfolio data series is static B43:C53, as it remains
to be static to be compared to segment series, how can it make it flexible when the new
data hits the file. any suggestions?
Any general advise to improve the dashboard will be highly appreciated as well.
thanks
TK
Is it possible, please advise.
Also the portfolio vs segment chart, portfolio data series is static B43:C53, as it remains
to be static to be compared to segment series, how can it make it flexible when the new
data hits the file. any suggestions?
Any general advise to improve the dashboard will be highly appreciated as well.
thanks
TK