Forum Discussion
Solved
FORMAT Function error
Hi guys, I am having difficulty in using the format function. I have this simple table: I am using the simple column chart to represent value based on the slicer selection. ...
Please mark my post as solution, this will also help others.
Please give Kudos for support.
TaroGulati Try this but it will return as text because it has different return types like whole number and percentage value.
Column = SWITCH(TableName[DIM],
"A",Format(30,"##"),
"B",FORMAT(40,"##"),
"C",FORMAT(0.5,"Percent"),
"D",FORMAT(0.6,"Percent")
)
Tahreem24 thanks for the suggestion. For table is not an issue. I am trying to represnt these values on line chart which doesn't support the text format of measure.