Forum Discussion
Helper IHighlight depending on the selection in a bar chart
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
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
4 Replies
- MFelix
Super User
Hi Gwendaline_p,
Check this post with a similar request to yours, you just have to select the hightlight instead of none option.
Regards,
Mfelix
Gwendaline_pHi ,
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
