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

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

There is no pre built solution for this, you  need to find  a work around for this, you require 02 measurs , one for the value and one for the percentage , like this   Total Value = SUM('YourTable'[YourValueColumn])
Percentage Change =
DIVIDE(
'YourTable'[YourValueColumn] -
CALCULATE(
'YourTable'[YourValueColumn],
DATEADD('YourTable'[DateColumn], -1, MONTH)
),
CALCULATE(
'YourTable'[YourValueColumn],
DATEADD('YourTable'[DateColumn], -1, MONTH)
)

 

 

after that in tool tip try to add both values percentage and value.

 

 

or add value in  water fall  chart  and percentage in card visuals but this requires lot of labor intensive work.
)