Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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
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!
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
On a line chart Legend is not available if more than one measure is used in the Y-Axis
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
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |