Forum Discussion
Change Font of Column Header if values are empty
Hi sasuser ,
Power BI doesn't support conditional formatting for column header font color in a Matrix visual. However, you can use conditional formatting to blend future month values with the background. Create measures to identify future months and set font color accordingly, then apply conditional formatting to the Matrix as described.
See the attached .pbix file for reference.
Hi sasuser ,
Power BI’s built-in Matrix visual doesn’t currently allow conditional formatting of column header font color, which is why the original DAX approach couldn’t produce the expected result. To create the same visual effect for future months, the solution is to ensure those month columns remain visible by using a measure that returns 0 instead of BLANK, preventing Power BI from hiding them. Conditional formatting is then applied to the matrix values and their backgrounds using a date-based measure. This makes future months blend into the report background so they appear faded or inactive, while the column layout and alignment stay intact. This method works within Power BI’s existing feature set and achieves the desired visual outcome without relying on custom visuals or unsupported functionality.
Thank you, idea of converting values to 0's instread of BLANKS might work. I will implement it next week when back to office. meanwhile, do you think you can share an example and steps to blend column header with the baxckground? I would greatly appreciate it.
Hi sasuser ,
Power BI doesn't support conditional formatting for column header font color in a Matrix visual. However, you can use conditional formatting to blend future month values with the background. Create measures to identify future months and set font color accordingly, then apply conditional formatting to the Matrix as described.
See the attached .pbix file for reference.Hi sasuser ,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.