Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Hello,
I am trying to add a tooltip of percent of column total for each stacked section on the columns in a stacked column chart in Power BI. I can't use a 100% stacked column chart. Right now my chart looks like this, and I want to add a tooltip so that the percent of the column total is displayed.
Stacked columns with legend
For example, the tooltip should read 89% for the light brown stack on the farther-right column and 11% for the bright yellow in the same column.
I've tried several different DAX measures as solutions, but none have resulted in the correct percentage being displayed.
The two that make the most sense are as follows, but the tooltip displays 100% for both:
DIVIDE(
SUM('Sales'[Amount]),
(CALCULATE(SUM('Sales'[Amount]),ALLEXCEPT('Market','Market'[Market with Highlight])))
)
DIVIDE(
SUM('Sales'[Amount]),
(CALCULATE(SUM('Sales'[Amount]),REMOVEFILTERS('Market'[Market with Highlight])))
)
Can anyone let me know what I'm doing wrong?
Thank you very much!
@KitD , You can try May2023, measure driven label. If that can help
https://powerbi.microsoft.com/en-us/blog/power-bi-may-2023-feature-summary/#post-23312-_Toc134425713