Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
AnkurSharma
Helper I
Helper I

Donut chart to show overall % on selection of Slicer.

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%
USA25%
Canada30%
China10%
India5%
Australia2%



Appreciate if you can attach Pbix.

Thanks for helping

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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.

vzhouwenmsft_0-1710318926989.png

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:

vzhouwenmsft_1-1710319184004.png

vzhouwenmsft_2-1710319191662.png

 

 

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.

View solution in original post

1 REPLY 1
Anonymous
Not applicable

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.

vzhouwenmsft_0-1710318926989.png

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:

vzhouwenmsft_1-1710319184004.png

vzhouwenmsft_2-1710319191662.png

 

 

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.

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors