Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have 2 tornado charts, i would like to see percantage and the real number together as data label, if it is possible (without creating a bookmark)? many thanks in advance.
Expected Answer:
4832K (26%) 914K (25%)
Hi @Setosa ,
As checked the Format pane settings, there is no option to customize the data label of tornado chart...
Best Regards
thanks but i guess it is not working.
@Setosa
To display both the real number and the percentage together as data labels in your tornado charts, you can concatenate them within your measure. Below is a modified version of your measure Tornado_Percent:
Tornado_Percent_Label =
VAR TotalAmount = CALCULATE ( [AOP @FY24 + AOP @FY25] )
VAR TotalAmountAllYears =
CALCULATE (
[AOP @FY24 + AOP @FY25],
ALLEXCEPT ( 'Calendar', 'Calendar'[Fiscal Year] )
)
VAR Percentage = DIVIDE ( TotalAmount, TotalAmountAllYears )
RETURN
FORMAT ( TotalAmount, "#,##0" ) & " (" & FORMAT ( Percentage, "0%" ) & ")"
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!