Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
ramshoney1225
Helper V
Helper V

How to give Different colors to the column heading in Power BI Matrix graph?

Hi 

 

I have a requriemnet as below for the Pivot table/ Matrix in Power BI.

 

ramshoney1225_0-1632307007901.png

 

I want to give a differnt background color for differnt column value heading in Matrix.

Please suggest if this is doable or not?. We can do it in Table view but my requirment is to do in Matrix view.

 

Thanks,

 

 

21 REPLIES 21
ciraheta
New Member

Hi, you should go to the Format Visual Panel, then in the Specific Column field, you can select the column you would like to personalize, then select where would you like to apply a background color or font color here is a sample.

 

ciraheta_0-1677199227130.png

 

v-xiaoyan-msft
Community Support
Community Support

Hi @ramshoney1225 ,

 

Have you solved your problem? If so, can you share your solution here and mark the correct answer as a standard answer to help other members find it faster? Thank you very much for your kind cooperation!

 

Hope it helps,


Community Support Team _ Caitlyn

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

mh2587
Super User
Super User

Can you provide me the pbix ?

 


Did I answer your question? If so, please mark my post as a solution!


Proud to be a Super User!




LinkedIn Icon
Muhammad Hasnain



I dont know how to share pbix file 😐 here

Upload the pbix to drive then share the link here and enable the access to public


Did I answer your question? If so, please mark my post as a solution!


Proud to be a Super User!




LinkedIn Icon
Muhammad Hasnain



Hi @mh2587 

If you have done that - its great.

can you share the same pbix to me - which you were able to do.

 

Thanks

https://drive.google.com/file/d/1lnStqW-bOfcN7EGB_hYnSNAhTxbwTPeG/view?usp=sharing

 

Hi You can acces the file and it 


Did I answer your question? If so, please mark my post as a solution!


Proud to be a Super User!




LinkedIn Icon
Muhammad Hasnain



Hi @mh2587 

 

Thanks for your support for sharing the pbix file. Im able to see its doable in your data of because of converstion of importing data to pivot.

 

But in my scineario i have just given 3 columns of data - but in real for me i have almost 22 columns in that excel sheet, which we already created report on it.

where we didnt have control to conver the entire sheet with 22 columns into a pivot import.

 

so in my case i'm getting the data in below view with 3 columns, which i'm not able to do - think it will not be doable if this is the case. Still do we have option to do if the data is coming as below for the table with 3 columns higlting below

 

ramshoney1225_0-1632318776170.png

 

mh2587
Super User
Super User

Diff.PNG

1.  Select the Matrix

2.  In the Visualizations pane under the paint poller (Format) select Field Formatting

3.  Select the column name from the dropdown

4.  Select the background color

5.  “Apply to Header” – On

6.  “Apply to Values” - Off
7. For the other columns follow same procedure just change the column name and background colour


Did I answer your question? If so, please mark my post as a solution!


Proud to be a Super User!




LinkedIn Icon
Muhammad Hasnain



Is this a feature that's been removed? I don't have field formatting.

Lawrenceiow_0-1697125813160.png

 

Indeed @Lawrenceiow! It seems impossible to change the font of a specific column header. Formatting matrices and tables still is quite a challenge unfortunately 

Hi 

 

Im giving you the below sample data.

CategorytypeValue
Category-ABenchmark23
Category-ARevenue24
Category-ASales25
Category-BBenchmark26
Category-BRevenue27
Category-BSales28
Category-CBenchmark29
Category-CRevenue30
Category-CSales31

 

Can you please use this data in MATRIX view and can you get the view what i was asking ?

 

ramshoney1225_0-1632309283159.png

 

Its not working for me in Matrix view - highlighed as below.

ramshoney1225_1-1632309674622.png

 

dC.PNG

I tried it worked for me 


Did I answer your question? If so, please mark my post as a solution!


Proud to be a Super User!




LinkedIn Icon
Muhammad Hasnain



select column name rather than value and disable the apply to value button


Did I answer your question? If so, please mark my post as a solution!


Proud to be a Super User!




LinkedIn Icon
Muhammad Hasnain



mh2587
Super User
Super User

1.  Select the Matrix

2.  In the Visualizations pane under the paint poller (Format) select Field Formatting

3.  Select the column name from the dropdown

4.  Select the background color

5.  “Apply to Header” – On

6.  “Apply to Values” - Off


Did I answer your question? If so, please mark my post as a solution!


Proud to be a Super User!




LinkedIn Icon
Muhammad Hasnain



Is this still possible in the new Visualizations panel? I've been unable to change the column header as Field Formatting is no longer available. 

header.PNG


Did I answer your question? If so, please mark my post as a solution!


Proud to be a Super User!




LinkedIn Icon
Muhammad Hasnain



@mh2587 , Thanks for your quick response.

 

Intially i did the same but the problem here is as you attached the screenshot of the (format)  as below

 

ramshoney1225_0-1632308002980.png


Font color is black
Back ground color is blue.

 

If i go with that properites then my Matrix will be like the below which the same background color is appled to 3 column headings.

 

ramshoney1225_1-1632308118045.png

 

But my requirement is each column heading background should be differnt as below.

 

ramshoney1225_2-1632308160381.png

 

 

for different heading colour you can field formatting apply to only headerDiff.PNG


Did I answer your question? If so, please mark my post as a solution!


Proud to be a Super User!




LinkedIn Icon
Muhammad Hasnain



Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.