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 !

speedramps's avatar
speedramps
Icon for Super User rankSuper User
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 !

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

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

    Great solution!