Forum Discussion

VoltesDev's avatar
VoltesDev
Icon for Helper V rankHelper V
4 years ago
Solved

Bar chart with data label percentage

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 t...
Tips and Tricks
  • speedramps's avatar
    speedramps
    4 years ago

    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's avatar
PaulDBrown
Icon for Community Champion rankCommunity Champion
4 years ago

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

  • VoltesDev's avatar
    VoltesDev
    Icon for Helper V rankHelper V
    4 years ago

    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,