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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.

Top Kudoed Authors