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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply

How to get slicer to highlight bar chart elements, not just filter the bar chart

Hi I'm using Power BI Desktop.

 

I've placed the slicer on the left of my screen so that I can select one or more options within the slicer (see below).

 

When I do, I want the line chart or bar chart to the right of the slicer to highlight the relevant elements, not filter them.

 

At the moment when I select Format > Edit Interactions, I can only filter the associated bar/line chart, not highlight.

 

How can I highlight?

 

Thanks.

 

Slicer with bar charts shownSlicer with bar charts shownI select an option in the slicer and the bar chart filters, but i want it to highlight.I select an option in the slicer and the bar chart filters, but i want it to highlight.

1 ACCEPTED SOLUTION
v-sihou-msft
Employee
Employee

@powerbi-learner

 

No, it's not possbile to make slicer to hightlight other visuals only without filtering data. For your requirement, you should use a Table visual and populate corresponding data field. When you click on an entry, it will hight the corresponding bar/line in chart. 

 

222.PNG

 

333.PNG

 

Regards,

View solution in original post

3 REPLIES 3
Beinexpowerbi
Advocate I
Advocate I

hi @powerbi-learner we have created a solution to this using dax .

 

Please check our latest blog on this :

https://www.beinex.com/blog/dynamic-highlight-bar-chart-with-slicer/

Unable to access the link. 

v-sihou-msft
Employee
Employee

@powerbi-learner

 

No, it's not possbile to make slicer to hightlight other visuals only without filtering data. For your requirement, you should use a Table visual and populate corresponding data field. When you click on an entry, it will hight the corresponding bar/line in chart. 

 

222.PNG

 

333.PNG

 

Regards,

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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