Forum Discussion
PBI Scenario Manager for Formattings?
Hi DeltaZero ,
As far as I know, Power BI doesn't support us to do this by SWITCH() function. The calculation in Power BI is based on columns, so there will be only one data type for a measure or a calculated column. You couldn't show different data type by one measure. Here I suggest you to try calculation group by third party tool - Tabular.
For refernece:
External tools in Power BI Desktop
You can refer to this blog to learn more details.
Creating Value Dynamic Formatting using Calculation Groups
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Any help please? I was wondering if I can use SWITCH() as part of the formatting?
Hi DeltaZero ,
As far as I know, Power BI doesn't support us to do this by SWITCH() function. The calculation in Power BI is based on columns, so there will be only one data type for a measure or a calculated column. You couldn't show different data type by one measure. Here I suggest you to try calculation group by third party tool - Tabular.
For refernece:
External tools in Power BI Desktop
You can refer to this blog to learn more details.
Creating Value Dynamic Formatting using Calculation Groups
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.