Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
nehajadhav166
Resolver I
Resolver I

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

1 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.

nehajadhav166_0-1652365885281.png

3) Map the value of the measure to it.

Now I can see values changing based on slicer selection.

 

Thanks,

Neha

 

View solution in original post

4 REPLIES 4
PabloDeheza
Solution Sage
Solution Sage

Hi @nehajadhav166 !
Try adding the column you have in your slicer as a Legend in you chart. The 4th field in the image below

PabloDeheza_1-1652356741338.png

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.

nehajadhav166_0-1652365885281.png

3) Map the value of the measure to it.

Now I can see values changing based on slicer selection.

 

Thanks,

Neha

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.