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.
ehartanto Tough one. If it is OK to convert to text, you can use FORMAT to achieve this.
apology if i hijacked this thread. I've managed to do this and happy to share my one. $,%, and many others. got one dynamic columns that dynamically took place for my more than 15 measures.
the one that i can't get around is the Style Icon. like for:
sales - use bar icons
percentage - use arrows growth icons.
and many more.. totally stucked with this :)... any tip? if i have to create my own external.. what research i need?
