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

     

     

Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
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

 

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

This is perfect!