Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, I am trying to use the Pick Function in a chart where i can change the dimension in the dimension field of a bar chart. but Pick function isnt picking it up. It is working with nested ifs, however.
I have used Pick function to change the measure values and i thought it would work the same for the Dimensions, but it isnt.
how to resolve this?
Hello,
On what action are you changing the dimension ?
You can show 1 dimension at a time in bar chart and Pick() takes an integer from 1 to n to show values.
Thanks,
Ashutosh
i was trying to replace dimensioins on the basis of pick. i have found the solution. it goes as follows:
Pick($(variable),Dim1,Dim2,....DimN)