Multiple conditional formating in the matrix

Hi aurora90 ,

>> if there a blank value appears for the KPI 'OTC' and Region "ANA" then return text "ongoing transition", but if KPI is "TAX" and Region "APAC" comment will be "not in scope for company AAAA".  And so one.

You need to fix it in your measure like:

Value1 = IF(MAX(Table[Measure]) = 'OTC'&&MAX(Table[Measure]) = 'ANA','ongoing transition',IF(MAX(Table[Measure]) = 'TAX'&&MAX(Table[Measure]) = 'APAC','not in scope for company AAAA',[VALUE]))

>>Second thing is colouring, so each measure have different treshold, so I cannot put same color scale to the whole matrix. Now, I've fixed it by adding to the raw data table column with color ID. 

You need to create a measure for your background color conditional format:

Please refer to https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai