Conditional formatting going crazy in matrix table with calculation group data and format function

[IP_Kornel]

Hi,
I want to show margin values with % formatting ofcourse and to make it happen with calculated group the only solution (correct me if I'm wrong) is to use FORMAT(x, "Percent"). But when I use FORMAT my conditional formatting is falling apart.

My conditional formatting rules in table

Calculation group conditional formatting rule

So when I don't use FORMAT function on "MARŻA" (MARGIN) it looks good (putting aside value formatting)

But the moment I only wrap the value around FORMAT() function it looks like this

If I add FORMAT to calculation group formatting rule like this

For some reason it only fixes 0 values

Negative values are still shown in green.

Any idea how to solve it?

I have no problem if I put the data the "normal" way without calculation group but I need to keep the values as calculation group since I need to be able to dynamically filter out columns from the matrix.

[Anonymous]

Hi @IP_Kornel ,

From your description, it appears that the desired conditional formatting (specifically for values less than 0) is not being achieved after the application of the FORMAT() function. This could be due to the fact that the FORMAT() function converts the number into a Text type, which might be affecting the outcome.

To better assist you, could you kindly provide the following information? It would be helpful to find out the solution. Thank you.

• The data contained in the referenced table 'BUDZET KPI'  (exclude sensitive data) with Text format: How to provide sample data in the Power BI Forum
• The column settings of the matrix
• Details about the calculation group

It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Best Regards

[IP_Kornel]

Any ideas? 🙄