Bar chart with data label percentage

[VoltesDev]

Hello guys,

Need advice with bar chart visual, can we have the data label shows the percentage instead value ?

So, the normal is like this ->

So instead the value 9.3k. it is displaying the percentage. Or is there custom visual that can make it the same result ?

Thanks

[Thennarasu]

Hi,

Right Click the Measure Value Change to Percent of grand total and
Measure Value Add in tooltips.

Thanks and Regards,
Thennarasu R

[speedramps · Accepted solution]

Hi VoltesDev

Try this and please leave kudos ...

1. Select a table visual instead of a graph.
2. Drag your category to the Axis
3. Drag sales twice to the Values field well.
4. Right click on the 1st sales values > Conditional formatting > Data bars.
5. Right click on the 2nd sales values > Show values as > Percentage of grand total.

Voila …  you now have both the value, % and a graph !

[PaulDBrown]

Great solution!

[VoltesDev]

Hi @speedramps ,

Yeah, it is actually a great idea and it's works!.

The only flaws is the data bar can't make it big enough, what I can is just increase the Row Padding to make it lools wide enough. But  anyway it's a good trick!

Thanks again

[PaulDBrown]

You will only be able to show one value as a label, but you can include the other value as a tooltip, or even create a report tooltip to show more insights.

[PaulDBrown]

Can't you create a % measure and use that instead in the bar chart?

[VoltesDev]

Ahh.. yaah I'm sorry, what was I thinking just now, of course I can do that 😂

However, is there by any chances we can have both displayed ? 

or can we have two separate chart but control together, so I will 2 chart : one with value and one with percentage, for example in my visual over there is Vertical bar, when it has long list will have vertical scroll control, so we use this scroll, the 2 chart will scroll at the same time. 

Thanks,