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 FOR...
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