cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
powerbi-learner
Helper I
Helper I

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
Microsoft

@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
Microsoft

@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
September Update

Check it Out!

Click here to learn more about the September 2022 updates!

Power BI Show episode 9

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power BI Dev Camp Session 26

New Date - Check it Out!

Mark your calendars and join us on Thursday, October 6 at 11a PDT for a great session with Ted Pattison!

Top Solution Authors