Conditional Formatting (Bug?)

[Anonymous]

Goodmorning,
this is the visual behavior of conditional formatted matrix according to measure value

The latter doesnt happen using continous axis 

BR

[amitchandak]

@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

[Anonymous]

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 following 

ColourTest = 
var x=max('Pianificato Elaborato (timestamp)'[CalendarioFermi.tota_tur])
RETURN
SWITCH(TRUE(), ISBLANK(x)=true,BLANK(), x=0, "Red", x>0, "Green", blank ())

Thanks

[Anonymous]

Hi @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