Forum Discussion
Waterfall showing value + percentage
Dear Community,
Is there a way to show in a waterfall diagram the value + percentage for each bar .. ?
Many thanks.
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
2 Replies
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.
)
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
