Forum Discussion
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
- IP_KornelFrequent Visitor
Any ideas? 🙄
- AnonymousNot 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 theFORMAT()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