Forum Discussion
Custom conditional Formatting for matrix per row different threshold for same row by filter on table
Hi kyrpav ,
Currently, conditional formatting in matrix is based on all values of the matrix. You cannot apply it based on individual rows. Would you please vote for the similar idea in Power BI forum which has been submitted to improve Power BI and make this feature coming sooner.
As a workaround, I suggest you create a calculated column like:
Calculated column = SWITCH(TRUR(),([Employee] = "Geogre" && Type = "Car1" && [salesamount] > 120K) ||([Employee] = "Geogre" && Type = "Car2" && [salesamount] > 200K),1 ,……………Then create conditional format based on the new column:
For more details, please refer to https://www.cloudfronts.com/conditional-formatting-by-row-in-a-matrix/
Best Regards,
Dedmon Dai
i changes a bit the main post to give you example cause the initial reply was exluded as spam
Hi kyrpav ,
Currently, conditional formatting in matrix is based on all values of the matrix. You cannot apply it based on individual rows. Would you please vote for the similar idea in Power BI forum which has been submitted to improve Power BI and make this feature coming sooner.
As a workaround, I suggest you create a calculated column like:
Calculated column = SWITCH(TRUR(),([Employee] = "Geogre" && Type = "Car1" && [salesamount] > 120K) ||([Employee] = "Geogre" && Type = "Car2" && [salesamount] > 200K),1 ,……………
Then create conditional format based on the new column:
For more details, please refer to https://www.cloudfronts.com/conditional-formatting-by-row-in-a-matrix/
Best Regards,
Dedmon Dai