Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 ?
Solved! Go to 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
Hi @Anonymous ,
Power BI creator team is soliciting opinions now. You could share your thoughts in the thread.
Hi @Anonymous ,
Power BI creator team is soliciting opinions now. You could share your thoughts in the thread.
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. ???
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
Hi @v-xuding-msft ,
Thanks for information. I have also voted to have this feature.
Hope it will come soon.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
118 | |
104 | |
77 | |
73 | |
52 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |