Forum Discussion

SteveWave's avatar
SteveWave
Frequent Visitor
1 year ago
Solved

Waterfall showing value + percentage

Dear Community, Is there a way to show in a waterfall diagram the value + percentage for each bar .. ? Many thanks.  
  • Kedar_Pande's avatar
    Kedar_Pande
    1 year ago

    SteveWave 

    Displaying both the value and percentage on each bar in a Waterfall Chart is not directly supported through native data label options.

    Workaround:

    Create Measures for Value and Percentage.

    Use a measure to combine the value and percentage as a single tooltip.

    TooltipLabel = 
    FORMAT([TotalValue], "#,##0") & " (" & FORMAT([PercentageOfTotal], "0%") & ")"

    Go to the Waterfall Chart, and under the Tooltips section, add your TooltipLabel measure.
    When hovering over each bar, it will display both the value and percentage in the tooltip.

     

    💌 If this helped, a Kudos 👍 or Solution mark would be great! 🎉
    Cheers,
    Kedar
    Connect on LinkedIn

Kedar_Pande's avatar
Kedar_Pande
Icon for Super User rankSuper User
1 year ago

SteveWave 

Displaying both the value and percentage on each bar in a Waterfall Chart is not directly supported through native data label options.

Workaround:

Create Measures for Value and Percentage.

Use a measure to combine the value and percentage as a single tooltip.

TooltipLabel = 
FORMAT([TotalValue], "#,##0") & " (" & FORMAT([PercentageOfTotal], "0%") & ")"

Go to the Waterfall Chart, and under the Tooltips section, add your TooltipLabel measure.
When hovering over each bar, it will display both the value and percentage in the tooltip.

 

💌 If this helped, a Kudos 👍 or Solution mark would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn