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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
apohl1
Helper I
Helper I

Display value and percentage in stacked bar chart

Hi all,

 

Does any of you know if it's possible to show both values AND percentage in a stacked bar chart? As an example, in the chart below, I'd like it to show 28% next to 30M, and 72% next to 79M.

 

Capture.PNG

 

 

 

 

Thank you in advance!

8 REPLIES 8
Bijen_Shah
Regular Visitor

Indeed , It is possible with some Power BI measures magic. @apohl1 @v-cazheng-msft @amitchandak 

I created 3 measures:
1. Count = COUNTROWS('Table')
2. Count % = 

DIVIDE([Count],
CALCULATE(COUNTROWS('Table'),ALLSELECTED('Legend'))
)
where Legend -> i had the category column showing buy/sell trades

3. 
Count Concat = [Count] & " (" & ROUND([Count %],2) * 100 & "%)"

Use the "Count Concat" measure in the D
ata Labels -> Values -> Custom Label field.

Screenshot of my solution:
Bijen_Shah_0-1698414025278.png

 


Let me know if this works for you!!

This is very elegant!

Thanks, it worked!

v-cazheng-msft
Community Support
Community Support

Hi @apohl1,

 

Currently, we are not able to display values along with percent in a Stack bar chart at the same time. You may consider these solutions.

1 Voting for similar ideas in Power BI ideas: https://ideas.powerbi.com/ideas/search-ideas/?q=values%20and%20percent%20%20stack%20bar%20chart

2 Take the solution from the super user d_gosbell  in this post: https://community.powerbi.com/t5/Desktop/Stacked-Bar-Chart-Percent-AND-Count/m-p/632510

3 Consider Tootip, the solution from v-cherch-msft in the same post above

 

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please let me know. Thanks a lot!

 

Best Regards,

Community Support Team _ Caiyun

Thank you for your reply! At least it confirms what I'd like to do is currently not available. I will vote for this idea to be implemented hopefully soon.

@apohl1 
Did I answer your question? Mark my post as a solution!
Appreciate your Kudos!! Happy to Help!
 
amitchandak
Super User
Super User

@apohl1 , this video has one solution , check if that can help

Change Data labels
https://www.youtube.com/watch?v=un4PkoGF3YM

Thanks for your message, but I'd like to show value and percentage at the same time, so unfortunately not a solution. 


Thanks anyway!

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors