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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.

Reply
Anonymous
Not applicable

How to plot % value in bar chart instead of numbers ?

Hi,

 

 

I want to plot the % value in the bar chart, instead of numbers. The % is calculated as
93 / 3046 = 3,05 %

330/ 3046 = 10,82%

and so on...

I have tried many DAX measures but did not get the expected result

Total table = DISTINCTCOUNT('Tables'[TableID]) =  3046

Number of columns in each table = 5 4 3 2 1

Number of tables with 5 columns = 93
% of tables having 5 columns = 93 / 3046 = 3.05 %

 % of tables having 4 columns = 330 / 3046 = 10,82 %

1.png

Any suggestion would be much appreciated ?

 

Thanks !

 

1 ACCEPTED SOLUTION
Greg_Deckler
Community Champion
Community Champion

In your Values area, whatever you have in there, use the little drop down arrow and choose "Show as" | "Percent of Grand Total"



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!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

2 REPLIES 2
Greg_Deckler
Community Champion
Community Champion

In your Values area, whatever you have in there, use the little drop down arrow and choose "Show as" | "Percent of Grand Total"



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!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...
Anonymous
Not applicable

Thanks @Greg_Deckler, I was also wondering if there any seperate measure to represent that value ?

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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