Show selected value on chart

[nehajadhav166]

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

[PabloDeheza]

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]

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]

On a line chart Legend is not available if more than one measure is used in the Y-Axis

[nehajadhav166 · Accepted solution]

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