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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
jborgesz
Regular Visitor

Percentage and Totals in a Stacked Chart

Hello, I have this chart with the sum of the different categories

jborgesz_0-1724783402738.png

And what I would like to do is have the total (which I already have) and the percentage difference from the previous month. Does anyone know how to show both pieces of information? I want the total for the stacked column and not individual totals.

 

5 REPLIES 5
Greg_Deckler
Super User
Super User

@jborgesz For whatever reason you can use a measure to control Data Labels in a stacked column chart but not Total Labels but will see if I can find anyting creative. Is this the standard stacked, clustered column chart or your own custom one?



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

Hey greg, thanks for your time, i use the standard stacked chart on power bi 

@jborgesz I would call this approach "unrefined" but maybe it is a starting point. See PBIX file attached below signature. Let me know if you need assistance in figuring out how it's done. Maybe I'll do a video on it.

 



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

I had a similar approach, but this chart in question is dynamic. The user can filter dates between a period of days, so the chart can be scrolled horizontally, which will cause the information to misalign

@jborgesz OK, wasn't sure since this is posted under Customer Visuals forum.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.

Top Kudoed Authors