Different measurement

[#1]

Hi all,

I've a requirement where i need to create a variables to use on the screen by users to adjust unit of measure between 3 options to display in measures.

e.g: Variables: vUnitOfMeasureSelect - possible values: Tonnes,GSV,Qty

My initial idea will be using LET to create the variables. But i'm not too sure how i can use the variables created to relate it to the columns i have in my tables.

e.g: I've Sales_Qty,Sales_Tonnes,Sales_GSV in 1st table

and FCST_Qty,FCST_Tonnes,FCST_GSV in 2nd table

How can i use selection of QTY,TONNES,GSV on my screen?

Thanks in advance.

[sparur]

Hello.

I think, you should create 3 copies of your chart, each copy for each value of variable.

And show/hide chart by value of variable (see Show Condition option in the Layout tab in properties of chart)

for example "Show condition": vUnitOfMeasureSelect= 'Tonnes' so this chart will be shown only when your variable will be equal Tonnes. etc...