Highlight depending on the selection in a bar chart

[Gwendaline_p]

Hi everyone ,

Did someone know how to highlight a value depending on the selection in a bar chart ?

Example : I choose in the filter X (it's an entity) and in the bar chart I saw X and other entity. I want to highlight the X entity like this :

Kind regards ,

Gwendaline

[MFelix]

Hi @Gwendaline_p,

Check this post with a similar request to yours, you just have to select the hightlight instead of none option.

https://community.powerbi.com/t5/Desktop/How-can-I-have-different-graphs-on-one-page-be-in-dependant...

Regards,

Mfelix

[Gwendaline_p]

Hi ,

I don't have this option : here is what I have

Kind regards ,

Gwendaline

[v-yuezhe-msft · Accepted solution]

Hi @Gwendaline_p，

If you only have a slicer and a bar chart, you are not able to highlight the section in bar chart when you selecting X in the slicer.

Create another pie chart using same fields that you use to create the bar chart. Click on the pie chart, then turn on “Edit interactions” under Format ribbon. This way, you will be able to choose “Highlight” in the bar chart, and when you choose X in pie chart, the X section in bar chart will be highlighted. For more details, please review the following example.

Another option is to click on the slicer, choose “None” in the bar chart after you click on the pie chart and choose “Highlight” in the bar chart. Then when you select X in the slicer, it will filter the data in Pie chart, after that, click on the filtered section in the pie chart, the X section will be highlighted in  the bar chart.

Thanks,
Lydia Zhang

[domnel]

I don't understand why you would ever do what you've suggested in the second half of your answer. If you wanted to have to click on something to highlight after you've used the slicer you would cut out the middleman and just click on the bar you want to highlight directly on the chart.

Seems to me like yet another basic thing that Power BI is incapable of.