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,

 

An addtional issue I have is that the 2 measures I am toggling need to display in different formats. 1 to 1 decimal place and the other to 4 decimal places. This solution works for me apart from being able to dynamically be able to set the format of the measure returned.

 

Does anyone know if this is possible?,

 

Thanks in advance for your help,

 

Cheers,

Jack

 

dkay84_PowerBI's avatar
dkay84_PowerBI
Microsoft Employee
8 years ago
Google: “Dax format”
  • 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. 

    • dkay84_PowerBI's avatar
      dkay84_PowerBI
      Microsoft Employee
      8 years ago
      Are your measures actual measures or calculated within the SWITCH measure? I wonder if they are separate measures each formatted themselves, and the SWITCH just calls them, if the formatting will be honored.
      • 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!

         

         

    • 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?