Forum Discussion
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
hi aurora90 ,
I don't believe that you can format the text in a matrix to do conditional formatting output. Unless you make a measure for each field that does what you want and put that measure into the value instead.
But, you can do the color and other items for the fields in the "value" section.
In the matrix, select "Conditional Formatting" and then you can modify the various attributes in there.