topic Re: How to show text on bar graph in DAX Commands and Tips

How to show text on bar graph

sdg1393 — Tue, 19 Dec 2023 22:26:21 GMT

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

Re: How to show text on bar graph

vicky_ — Tue, 19 Dec 2023 22:40:39 GMT

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