Forum Discussion
Helper IHighlight depending on the selection in a bar chart
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
Helper IHi ,
I don't have this option : here is what I have
Kind regards ,
Gwendaline
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
domnelAdvocate I
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.