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

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
Microsoft Employee
Microsoft 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
Microsoft Employee
Microsoft 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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

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