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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Leon999
Regular Visitor

100% Stacked column chart with percentage and count values mixed

Hello,

 

I`ve been searching for a solution but can`t find it anywhere so here`s my issue:

I need to show percentage but also count on the same 100% stacked column chart. I`ve found that it`s possible in line and clustered column chart be setting second Y-axis and putting % on the line moved to the bottom, however, I really need this in 100% stacked column chart due to amount of data shown together in one chart (it would be very indistinct in clustered column chart). Below example to visualize my issue:

example.PNG

 

Will be very thank-full for your assistance.

3 REPLIES 3
Anmolgan
Post Prodigy
Post Prodigy

@Leon999 You can create a measure to show the counts and use that in the tooltip option for the current visual.

@Anmolgan thank you for replying, I know it is possible to show also count when moving a cursor on the chart, but I need this to be shown on columns all the time the same way as % is shown to see amount differences as well, without checking each one with cursor by tooltip.

 

I`ve found that this is being voted here https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/34255738-enable-more-data-label-o... so apparently it`s still not available in Power BI, but wanted to be sure there is no other way as this is an important part of my project

@Leon999 thats the only reply in which you can show it for now, am not sure if there is any other method to do so, however you can wait for a reply from someone else, if they have any better ideas to do this.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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

Top Solution Authors