Formatting Columns in an Array

[Syndicate_Admin]

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!

[Anonymous]

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.

[lbendlin]

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