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

     

     

v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
9 years ago

Hi SHDJason,

 

Based on my testing, the solution provided above should work in your scenario. Have you tried them? If you still have any question feel free to post here.:smileyhappy:

 

In addition, if the solution works, could you accept the corresponding reply as solution to help others who may have similar issue easily find the answer and close this thread?

 

Regards

SHDJason's avatar
SHDJason
Advocate II
9 years ago

sorry, i haven't had a chance to test the solution yet. I'll close it as soon as i do. should be this week.