Hi Experts,
I'm working on a KPI but the problem is that I wanted to be flexible that the user can click on a selection and the dimension of all the charts will be replaced by the dimensions corresponding to the user's selection.
I'm using a 'Variable Input' object to store the selection of the user into a Variable.
Then, the variable will be my condition in an if-else statement inside the Dimensions Fx.
Here's a sample of that expression:
=If(vDimensionSelection = 'Books', BookNames,
if(vDimensionSelection = 'Cars', CarBrands,
if(vDimensionSelection = 'Fruits', FruitNames,
if(vDimensionSelection = 'Country', CountryNames))))
Thank you in advance!
