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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Viksha
Frequent Visitor

Conditional formatting of a row subtotal in a pivot table

Hi,

 

I want ta apply a color code to the '#recalls' subtotal - it should be a gradient.

Screenshot 2024-05-26 110817.png

 

However, I didn't find an option of contidinal gradient formatting for a subtotal.

Idead please?

 

1 ACCEPTED SOLUTION
parry2k
Super User
Super User

@Viksha in this case you have to create your logic for gradient color, you can look at this video on my channel and can help you to create your own gradient color. How to create your own color gradient scale for each column in a matrix visual - Part 2 (youtube.com...



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

View solution in original post

3 REPLIES 3
parry2k
Super User
Super User

@Viksha in this case you have to create your logic for gradient color, you can look at this video on my channel and can help you to create your own gradient color. How to create your own color gradient scale for each column in a matrix visual - Part 2 (youtube.com...



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

parry2k
Super User
Super User

@Viksha you can, on conditional formatting chose totals only

 

parry2k_0-1716739394381.png

 

 

 



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

@parry2k thank you! Is thre a way to appy conditional formatting on total and seperately on the rows of the same measure? (I see that this option exists in the dropbox from your screenshot, but it relates to the values in the row and the total as part of the same set and locig and therefore the color is biased towards total)

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

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

Top Solution Authors