Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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
Solved! Go to Solution.
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
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
User | Count |
---|---|
17 | |
17 | |
14 | |
13 | |
13 |
User | Count |
---|---|
17 | |
14 | |
11 | |
10 | |
8 |