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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
sdg1393
Frequent Visitor

How to show text on bar graph

Hi,

 

I have a simple bar chart that shows % value (numerator / denominator) , now the requirement is to show numerator and denominator value along with % value ( not as tooltip) on the bar itself  - for example - 50% (10/20) instead of 50% . Since % field is number value so I can't have text in the bar chart.

 

Is there any way to show it [50% (10/20)]using some custom visuals like deneb or any other way? I don't have any idea about deneb so looking for an spossible solution for this requirement.

 

please share your ideas if you came accross this situation earlier.

 

Thanks

1 ACCEPTED SOLUTION
vicky_
Super User
Super User

The more recent versions of powerBI have custom labels, so you can format your own text for graphs and still use the out-of-box visuals. I would create a measure like:

Label = FORMAT(DIVIDE([numerator], [denominator]), "00%") & " " & [numerator] & " " & [denominator]

and use that, or you can experiment with the dynamic formatting options for measures.

Check out the following:
https://www.sqlbi.com/articles/introducing-dynamic-format-strings-for-dax-measures/

https://powerbi.microsoft.com/en-gb/blog/power-bi-may-2023-feature-summary/#post-23312-_Toc134425713

 

View solution in original post

1 REPLY 1
vicky_
Super User
Super User

The more recent versions of powerBI have custom labels, so you can format your own text for graphs and still use the out-of-box visuals. I would create a measure like:

Label = FORMAT(DIVIDE([numerator], [denominator]), "00%") & " " & [numerator] & " " & [denominator]

and use that, or you can experiment with the dynamic formatting options for measures.

Check out the following:
https://www.sqlbi.com/articles/introducing-dynamic-format-strings-for-dax-measures/

https://powerbi.microsoft.com/en-gb/blog/power-bi-may-2023-feature-summary/#post-23312-_Toc134425713

 

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

May 2025 Monthly Update

Fabric Community Update - May 2025

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