Forum Discussion
cv2qm
Helper I
6 years agoConditional Formatting for Entire Row in Matrix table
Hello, I am trying to get colour on entire row. I can colour only for specific value or column. But i need it for entire row. Requriement: Want to colour entire row based on number of empt...
amitchandak
Super User
6 years agoHasonevalue is needed when you select the parameter value. For the measure, you can write direct conditions.
For row you have to repeat it for each column. This means the same condition for all columns.
Color Brand = if(FIRSTNONBLANK('Item'[Brand],BLANK())="Brand 11","red","green")
Color scatter = if(SUM(Sales[Net Sales])>2500 && SUM(Sales[Margin])>400,"green","red")
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Proud to be a Datanaut Connect on Linkedin