Change value formatting based on KPI selected in variable

I have a card that allows the user to select which metric (Sales, Units, Margin %, etc) they want to graph by, using a variable control.

Is there a way to force data formatting to be 'currency' when 'sales' is selected for example? Then when a user selects 'units', we'd want the formatting to now be shown as 'number'. With margin %, we'd have it automatically format as a 'percentage'.

Thanks in advance,

Michael

Best Answer

  • trafalger
    trafalger Coach
    edited June 2023 Answer ✓

    To my knowledge, is not possible to programmatically change units like that. I've done very messy string manipulations doing what you described but I don't recommend it and your totals won't work.

Answers

  • trafalger
    trafalger Coach
    edited June 2023 Answer ✓

    To my knowledge, is not possible to programmatically change units like that. I've done very messy string manipulations doing what you described but I don't recommend it and your totals won't work.