Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a requirement to create 2 measure. When i choose measure 1, the corresponding data is shown in a bar chart. Similarly when measure 2 is chosen the corresponding data is displayed. I want these 2 measure to be present in a filter object. Please let me know if there is any work around available for this.
Thanks,
Monu
Adding to the above, i tried the variable extension but when the value that i need in the variable is set expression, it isnt showing the data correctly, it is just aggregating the data and shows same value for all data points.
Please help as soon as possible.
Thanks,
Monu
Hi Monu, you can try using variable extension to switch between 1 and 2 (simple numbers), and use the variable as a condition in chart expression:
Pick(varName
, // Expression for 1
, // Expression for 2
)
Pick returns the expression in the position asked by the first parameter: