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!Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register 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