tornado chart (percentage and real number together)

[Setosa]

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

    )

)

[v-yiruan-msft]

Hi @Setosa ,

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

Best Regards

[Setosa]

thanks but i guess it is not working.

[johnbasha33]

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