topic Re: tornado chart (percentage and real number together) in DAX Commands and Tips

tornado chart (percentage and real number together)

Anonymous — Wed, 10 Apr 2024 09:53:57 GMT

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%)

Tornado_Percent =

DIVIDE (

CALCULATE ( [AOP @FY24 + AOP @FY25] ),

CALCULATE (

[AOP @FY24 + AOP @FY25],

ALLEXCEPT ( 'Calendar', 'Calendar'[Fiscal Year] )

)

Re: tornado chart (percentage and real number together)

johnbasha33 — Wed, 10 Apr 2024 10:59:40 GMT

Anonymous
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 !!

Re: tornado chart (percentage and real number together)

Anonymous — Wed, 10 Apr 2024 13:36:06 GMT

thanks but i guess it is not working.

Re: tornado chart (percentage and real number together)

Anonymous — Wed, 01 May 2024 09:45:00 GMT

Hi Anonymous ,

As checked the Format pane settings, there is no option to customize the data label of tornado chart...

Best Regards