cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

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!

7 REPLIES 7
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!!

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
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors