Forum Discussion

xiumi_hou's avatar
xiumi_hou
Post Partisan
6 years ago
Solved

Quick question for measure format data

Dear all,   I have below switch measure: Current Month_Session = SWITCH(                             MIN('Measure Filter - Session'[Number]) ,                             ----------------------...
Need Help
  • parry2k's avatar
    parry2k
    6 years ago

    xiumi_hou If you want this as a number, you cannot have mixed format for the same measure. You have to create seperate measure for each format option you want. 

parry2k's avatar
parry2k
Super User
6 years ago

xiumi_hou you can use format function to define the format for each measure

  • xiumi_hou's avatar
    xiumi_hou
    Post Partisan
    6 years ago

    parry2k  Hi Parry, 

     

                    The red one is a measure, and I put the format as percentage. However, when I put all the calculate measures as a new a measure(Current Month_Session), because the other calculate measures in the switch measure is integar, so I have to put the switch measure format as general, How should I make 10(red) as percentage? 

    • parry2k's avatar
      parry2k
      Super User
      6 years ago

      xiumi_hou something like this and this post will help

       

       

      Current Month_Session =
VAR __myValue =  SWITCH(
                            MIN('Measure Filter - Session'[Number]) ,
                            --------------------------------------
                            1,[Count_Sessions_Scheduled],
                            8,[Scheduled_without_cancelled_24hrs],
                            2,[Count_Held_Sessions],
                            3,[Count_A1_Assessment_Held],
                            6,[Count_Sessions_Cancel/Missing],
                            9,[Count_Sessions_Cancel_outside 24],
                              10,[Count_Percentage_Missing/Cancelled]
                            )
 RETURN
IF ( 
MIN('Measure Filter - Session'[Number]) = 10, 
FORMAT( __myValue, "Percent"),
FORMAT( __myValue, "General Number")
)

       

       

      • xiumi_hou's avatar
        xiumi_hou
        Post Partisan
        6 years ago

        Hi parry2k  Thank for the reply.  After revising, the new measure we created is a "Text" format. However, I would like to put the meaure as the value of bar chart. The bar chart can not recognize text. Any suggestion to revise? Thank you so much!