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

Hi,

 

Thanks again for the reply. The measures are real measures. One to 1 decimal place, the other to 4 decimal place. My issues seems to bethat I need to format the field in the table that will display the measure based on the selection. And the overides the format of the individual measure.

 

The measure I am displaying is :

 

 Impacts/TVR = IF(ISCROSSFILTERED('Measure Dimensions'[Measure]),SWITCH( TRUE(), VALUES('Measure Dimensions'[Measure]) = "Impacts",[Impacts],VALUES('Measure Dimensions'[Measure]) = "TVR",[TVR],BLANK()),BLANK())

 

Impacts is 1 decimal place. TVR is 4 decimal places. If I set the Impacts/TVR measure to General (Auto) it actual displays 4 decimals for Impacts and 2 for TVR. Which is odd!

 

 

dkay84_PowerBI's avatar
dkay84_PowerBI
Microsoft Employee
8 years ago
Have you set formatting in the table itself? Maybe set it to default/auto and see if it will detect the formatting of the measures