Forum Discussion

Resolver I

4 years ago

Solved

Show selected value on chart

Hi Experts,

In my report, I have a slicer and line chart.

On selection of value in a slicer, the line chart gets filtered. But I can not see which value is selected from a slicer in the chart.

Is there any way to show the selected value from the slicer in the chart?

Thanks,

Neha

nehajadhav166
4 years ago
Hi PabloDeheza ,

Thanks for the clarification.
I solved the issue as below:
1) Created a measure that calculates the selected value.
2) Then launch the conditional formatting dialog by right-clicking the “Title text” area in the property pane card of the chart and picking Conditional formatting.
3) Map the value of the measure to it.
Now I can see values changing based on slicer selection.

Thanks,
Neha

4 Replies

PabloDeheza
Solution Sage
4 years ago
Hi nehajadhav166 !
Try adding the column you have in your slicer as a Legend in you chart. The 4th field in the image below
Let me know if that helps!
- nehajadhav166
  Resolver I
  4 years ago
  Hi PabloDeheza ,
  
  I tried mapping legend but somehow I am not able to drag/map value to legend.
  Not sure what is wrong. Do I have to enable any setting to map legend?
  
  Thanks,
  Neha
  - PabloDeheza
    Solution Sage
    4 years ago
    On a line chart Legend is not available if more than one measure is used in the Y-Axis