Forum Discussion
Solved
Multiple Number Format in the Same Column
Hello, I am having difficulty having multiple number formats in the same column. I had it in the same column for drilling down and filtering purposes from different entities. For example, here i...
You can create a measure with multiple format.
Measure = SWITCH(MAX('Table'[Metric]), "Occupancy",FORMAT(SUM('Table'[Amount]),"Percent"), "% Margin", FORMAT(SUM('Table'[Amount]),"Percent"), SUM('Table'[Amount]))
Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
You can create a measure with multiple format.
Measure = SWITCH(MAX('Table'[Metric]),
"Occupancy",FORMAT(SUM('Table'[Amount]),"Percent"),
"% Margin", FORMAT(SUM('Table'[Amount]),"Percent"),
SUM('Table'[Amount]))
Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
This is exactly what I needed and it's a simple solution. Thanks!!