Forum Discussion
Solved
Quick question for measure format data
Dear all, I have below switch measure: Current Month_Session = SWITCH( MIN('Measure Filter - Session'[Number]) , ----------------------...
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")
)
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!