Forum Discussion

SHDJason's avatar
SHDJason
Advocate II
9 years ago
Solved

How to display different measures using a selector

Hi. I could not find the answer to this in other places, so I'll ask it here.     I would like to create a selector that will render different measures on the same chart.   For instance, I have a...
Need Help
Show and Tell
Tips and Tricks
  • Phil_Seamark's avatar
    Phil_Seamark
    9 years ago

    I've managed to acheive this using a measure table.

     

    Download the following PBIX file

     

    https://1drv.ms/u/s!AtDlC2rep7a-jkiRG_LyHcv0RSXI

     

    You'll notice on the 2nd page called 'All Sorts' you can choose different Measure names from the box in the top left and it works.

     

    I create a static table called [Dynamic] that carries measures and then reference them in a calculated measure on the fly

     

     

jkenne01's avatar
jkenne01
Frequent Visitor
8 years ago

Thanks for the reply but FORMAT returns a text value so my measures would be converted to text. So this won't work unfortunetly. 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

I'm having the same problem where I have to choose one data type for my entire group of measures. For example, I can't use decimal for one measure, and integer for another. It's either all decimal or all integer.

 

Has anyone found a solution for having a metric selector slicer that allows different data types for different measures?