Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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 !!
User | Count |
---|---|
70 | |
46 | |
21 | |
21 | |
15 |
User | Count |
---|---|
124 | |
42 | |
39 | |
28 | |
24 |