Forum Discussion

IP_Kornel's avatar
IP_Kornel
Frequent Visitor
2 years ago

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

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.

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    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.

    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