Forum Discussion
Conditional Formatting (Bug?)
Goodmorning,
this is the visual behavior of conditional formatted matrix according to measure value
The latter doesnt happen using continous axis
BR
3 Replies
Anonymous , I Hope you are having the year in the above matrix visual's column field. In conditional formatting, we use some function(Min/Max) on categorical value, because of which it can take future or past value if the year is not present and available in the table
The measure used can also be the reason, but need to check
Of course it's included the year, it's embedded Date Hierarchy
It's not a measure problem as you can see, the correct value is displayed --> it's the conditional formatting
Measue is the followingColourTest = var x=max('Pianificato Elaborato (timestamp)'[CalendarioFermi.tota_tur]) RETURN SWITCH(TRUE(), ISBLANK(x)=true,BLANK(), x=0, "Red", x>0, "Green", blank ())
ThanksHi Anonymous ,
How did you set your matrix visual? Does the field [CalendarioFermi.tota_tur] also be included in the matrix visual? In order to get a better understanding on your problem and give you a suitable solution, could you please provide some sample data in the table 'Pianificato Elaborato (timestamp)' and expected result with special examples and backend logic? It would be helpful to find out the solution. You can refer the following link to share the required info:
How to provide sample data in the Power BI Forum
And 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
