Forum Discussion
sasuser
7 months agoRegular Visitor
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...
- Anonymous7 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.
sasuser
7 months agoRegular Visitor
Thanks! I am not seeing fx option believing data is in text datatype could be the reason. Is any workaround possible to figure this out?