Multiple datatypes for a calculated field

I have created a parameter to switch the view between two values.

image

Actual vs Index:
Actual is % values, and
Index is decimal points

Is there a way I can dynamically set the data type to show % when view by is Actual and decimal points when view by is Index?

Hello,

There’s currently no way to achieve this functionality. I’ve tagged this as a #feature-request. Please see this link for a workaround. https://community.amazonquicksight.com/t/conditional-formatting-assigning-metric-format-based-on-parameters/6030/2

1 Like

Thank you for providing the workaround Imran…
Though, I don’t think the workaround is feasible in my case as I have a big table with multiple calculated fields… so, basically I’d have to duplicate the entire table thus affecting the load time after every filter change…