Don't miss your chance to take the Fabric Data Engineer (DP-700) exam on us!
Learn moreThe FabCon + SQLCon recap series starts April 14th at 8am Pacific. If you’re tracking where AI is going inside Fabric, this first session is a can't miss. Register now
In Power BI, my donut chart displays the population percentages for each country, like 25% for the USA and 30% for Canada. When I choose a country in the slicer, such as the USA, the chart shows 100% for that country. But I want it to always display the overall country percentage, which is 25% for USA, even when I select a specific country. Alternatively, I want the selected country to be highlighted while the others become opaque. If I disable the slicer interaction in edit mode, the chart displays all countries without any change when I use the slicer.
Is there anyother way when i select country USA in slicer Donut chart highlights that country but should or show that country % which is 25% not 100%
| Country | % |
| USA | 25% |
| Canada | 30% |
| China | 10% |
| India | 5% |
| Australia | 2% |
Appreciate if you can attach Pbix.
Thanks for helping
Solved! Go to Solution.
Hi @AnkurSharma ,
The following article mentions the highlighting options that can be set for visual objects:
Change how visuals interact in a report - Power BI | Microsoft Learn
But as far as I know, Power BI does not support the use of cross-highlighting in donut charts; donut charts only support cross-filtering and None. Unable to implement selection in highlight slicer.
But as far as I know, Power BI does not support the use of cross-highlighting in donut charts; donut charts only support cross-filtering and None. Unable to implement selection in highlight slicer.
For your requirement to display the overall percentage, you can additionally create another visualization object, using the following dax expression:
Total = CALCULATE(SUM(Tabelle1[%]),ALL(Tabelle1))
Final output:
Best Regards,
Wenbin Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @AnkurSharma ,
The following article mentions the highlighting options that can be set for visual objects:
Change how visuals interact in a report - Power BI | Microsoft Learn
But as far as I know, Power BI does not support the use of cross-highlighting in donut charts; donut charts only support cross-filtering and None. Unable to implement selection in highlight slicer.
But as far as I know, Power BI does not support the use of cross-highlighting in donut charts; donut charts only support cross-filtering and None. Unable to implement selection in highlight slicer.
For your requirement to display the overall percentage, you can additionally create another visualization object, using the following dax expression:
Total = CALCULATE(SUM(Tabelle1[%]),ALL(Tabelle1))
Final output:
Best Regards,
Wenbin Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
| User | Count |
|---|---|
| 53 | |
| 39 | |
| 37 | |
| 19 | |
| 18 |
| User | Count |
|---|---|
| 67 | |
| 66 | |
| 34 | |
| 32 | |
| 29 |