Forum Discussion
Formatting Columns in an Array
Good afternoon
I have an array and I want to color according to the block, this is the matrix
| CHILD | BARCEL | MARINELA | |||
| Requests | Billing | Requests | Billing | Requests | Billing |
| 12 | 10 | 15 | 14 | 7 | 5 |
BIMBO in blue, BARCEL in green and MARINELA in yellow, is there a way? even if it is in DAX.
Thank you very much in advance!
2 Replies
- lbendlinSuper User
Solved: Formatting Column headers in matrix - Microsoft Fabric Community
If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.fabric.microsoft.com/?forum=2d80fd4a-16cb-4189-896b-e0dac5e08b41
- AnonymousNot applicable
Thanks for the reply from lbendlin , please allow me to provide another insight:
Hi Syndicate_Admin ,
As far as I know, Power BI matrices only allow custom colors for Values. If you want to set the color of column headers, you can only set a single color for the entire column header.
If your data is in the following format, you can use ‘Specific column—Apply to header’ to assign a specified color to each column in Values to achieve a similar effect as customizing column header colors.
However, based on your data, you can only set custom colors for Requests and Billing, while CHILD, BARCEL, and MARINELA have always been columns in the matrix, so you cannot customize their colors
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.