Column header Background color change with multiple colors

[Anonymous]

Dear All,

I want to change background color of column headings in below pivot table as per below -

1- Activity Target/Activity Actual/ Activity Achv % ---->  Blue color

2- Farmer Target/Farmer Actual/ Farmer Achv % ---->  Red color

3- Acreage Target/Acreage Actual/ Acreage Achv % ---->  Black color

Please help me how can be it possible ? 

[v-xuding-msft · Accepted solution]

Hi @Anonymous ,

Unfortunately, the conditional formatting does not apply for the subtotal and total in current release desktop. Here is a similar idea, you could click to vote it up:

Conditional Formatting for Total and Subtotals in Matrices

It may be released in Jul 2020. Please reference the documents to learn more latest messages about it.

Conditional formatting for totals and subtotals 

What's new and planned for Power BI 

[v-xuding-msft · Accepted solution]

Hi @Anonymous ,

Power BI creator team is soliciting opinions now. You could share your thoughts in the thread.

https://community.powerbi.com/t5/Desktop/Conditional-formatting-for-totals-and-subtotals-feedback/td-p/1076595

[Greg_Deckler]

Not aware of a way to dynamically control column heading colors.

[Anonymous]

OK @Greg_Deckler 

Thanks for quick response. 

Secondly I have applied conditional formatting on % values as you can see in the snapshot.

Can I apply it on "Total" row. ???

[v-xuding-msft · Accepted solution]

Hi @Anonymous ,

Unfortunately, the conditional formatting does not apply for the subtotal and total in current release desktop. Here is a similar idea, you could click to vote it up:

Conditional Formatting for Total and Subtotals in Matrices

It may be released in Jul 2020. Please reference the documents to learn more latest messages about it.

Conditional formatting for totals and subtotals 

What's new and planned for Power BI 

[Anonymous]

Hi @v-xuding-msft , 

Thanks for information. I have also voted to have this feature. 

Hope it will come soon.