Forum Discussion
Formatting two Column Headers in a Matrix table
- Anonymous1 year ago
Hi mmrisk ,
Power BI does not currently support individual column header colors and can only set a uniform color for all column headers.
But you can try the following workaround by using the measure header to replace the column header of a field.
Create the following measures to represent the values under different 'Risks'.
Low = CALCULATE( SUM('Table'[Value]), 'Table'[Risk] = "Low")Medium = CALCULATE( SUM('Table'[Value]), 'Table'[Risk] = "Medium")High = CALCULATE( SUM('Table'[Value]), 'Table'[Risk] = "High")Use these three measures as the value of the matrix.
Set the font color for the headers of each of the three measures.
In this way, the 'Status' column header color is black.
And the measure value header replaces the 'Risk' column header, which can be set to a different color.Please see the attaced pbix for referenece.
Best Regards,
Dengliang Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi mmrisk ,
Power BI does not currently support individual column header colors and can only set a uniform color for all column headers.
But you can try the following workaround by using the measure header to replace the column header of a field.
Create the following measures to represent the values under different 'Risks'.
Low = CALCULATE( SUM('Table'[Value]), 'Table'[Risk] = "Low")Medium = CALCULATE( SUM('Table'[Value]), 'Table'[Risk] = "Medium")High = CALCULATE( SUM('Table'[Value]), 'Table'[Risk] = "High")
Use these three measures as the value of the matrix.
Set the font color for the headers of each of the three measures.
In this way, the 'Status' column header color is black.
And the measure value header replaces the 'Risk' column header, which can be set to a different color.
Please see the attaced pbix for referenece.
Best Regards,
Dengliang Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Than you very much,
This solution works for me.
The caveat for other users is that you will need to do additional work to create a Grand Total that sums the individual Low/Medium/High values.
Thanks again.