Dynamic Formatting In Switch() without Format()

[Anonymous]

Hi-

I have a switch function where i switch between whole numbers and percentages. This switch function is inside a matrix with conditional formatting.

I need the the the switch fucntion to display as a whole number, and the percent to display as a percentage. Unforuntatly the Format() function doesn't work for me because it converts the value to text and therefore my conditional formatting doesn't work. Are there any workarounds to this?

[RafalK]

Hi - you can do that now in Power BI.

Here is my tutorial on how to do that:

https://community.powerbi.com/t5/Desktop/Dynamic-formatting-of-measures-tutorial/td-p/1297373?fbclid...

[v-juanli-msft · Accepted solution]

Hi @Anonymous 

Create measures, then configure conditional formatting for Measure  using the Measure 2

Measure = IF(SUM(Sheet2[value])=INT(SUM(Sheet2[value])),FORMAT(SUM(Sheet2[value]),"General Number"),FORMAT(SUM(Sheet2[value]),"Percent"))

Measure 2 = IF(SUM(Sheet2[value])>1,1,0)

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.