Forum Discussion
Format loss when unpivoting columns
I am working on a report where in the source file, I have a set of columns expressed in different format types (a few are percentages, some are currency, others are fixed decimal number). Because my...
Use a SWITCH measure. See Write Conditional Statement Using SWITCH in DAX and Power BI - RADACAD for guidance.
You could also use a Calculation Group, but that is next level. A SWITCH measure is the cleanest and quickest to implement. Only explore CG's if the performance is not acceptable.
I tried SWITCH but is there a way to maintain different formatting options within that expression? I couldn't figure it out
See this article.
Dynamic Formatting of Switch Measures in Power BI 💡 - Excelerator BI
or use Calcuation Groups, which can use dynamic formatting and retain numeric formats. But you'd need to reveiw the entire SQL BI series on CG's before using them. Calculation Groups - SQLBI