Change value formatting based on KPI selected in variable

M_Gonzalez

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

trafalger

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.

trafalger

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.