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...
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