Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Conditional formatting for a Row header in Matrix visual

I have a Matrix visual in powerBI, I would like to highlight few rows in row header based on date column. I could see for all the columns added in the values section there is a conditional formatting...
Need Help
Show and Tell
Tips and Tricks
  • Sahir_Maharaj's avatar
    Sahir_Maharaj
    2 years ago

    Hello Anonymous,

     

    You can create a custom column that includes the formatting logic. This column can concatenate the row header value with a special character or text, based on your condition (While this doesn’t change the color or style of the row header, it  differentiates the rows based on your condition)

    RowHeaderWithCondition = 
IF (
    [YourDateColumn] < TODAY(), 
    "🔴 " & [RowHeaderColumn], 
    [RowHeaderColumn]
)

    You can also try conditionally format the cells in the matrix based on the row header value (Setting the background color of the cells in the values section of the matrix based on your date condition)

     

    Should you require any further assistance, please do not hesitate to reach out to me.

Sahir_Maharaj's avatar
Sahir_Maharaj
Icon for Super User rankSuper User
2 years ago

Hello Anonymous,

 

You can create a custom column that includes the formatting logic. This column can concatenate the row header value with a special character or text, based on your condition (While this doesn’t change the color or style of the row header, it  differentiates the rows based on your condition)

RowHeaderWithCondition = 
IF (
    [YourDateColumn] < TODAY(), 
    "🔴 " & [RowHeaderColumn], 
    [RowHeaderColumn]
)

You can also try conditionally format the cells in the matrix based on the row header value (Setting the background color of the cells in the values section of the matrix based on your date condition)

 

Should you require any further assistance, please do not hesitate to reach out to me.