Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
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
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi ,
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
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |