Forum Discussion

sasuser's avatar
sasuser
Regular Visitor
7 months ago
Solved

Change Font of Column Header if values are empty

In my data I have 2026 months as columns (jan as column 3), Feb Column 4, etc. Col 1 is KPIs, Col2 is KPI category. Created matrix: KPIs in Rows, Jan 2026 in Values, Feb 2026 in Values, so on. Brough...
Need Help
  • Anonymous's avatar
    Anonymous
    7 months ago

    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.

Anonymous's avatar
Anonymous
Not applicable
7 months ago

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.

Anonymous's avatar
Anonymous
Not applicable
7 months ago

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.