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...
  • speedramps's avatar
    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 !