Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
1 year ago

Formatting Columns in an Array

Good afternoon

I have an array and I want to color according to the block, this is the matrix

CHILDBARCELMARINELA
RequestsBillingRequestsBillingRequestsBilling
1210151475

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

  • Anonymous's avatar
    Anonymous
    Not 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.