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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors