How to make entire row in pivot grey, based on value in rows?

[robbert-bi]

Hi. I have a pivot with a measure in the "Values", the Month in the "Columns", the Employee, Status and Project in the "Rows". It looks like the table below. With conditional formatting on the measure I can make all the values which belong to status "Done" grey. However, this only gives a color to the values which belong to the measure and not to the cells marked in yellow below. How do I make the values in the "Status" column grey?

[v-prasare]

Hi @robbert-bi,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for your issue worked? or let us know if you need any further assistance here?

Thanks,

Prashanth Are

MS Fabric community support

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query

[v-prasare]

Hi @robbert-bi,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for your issue worked? or let us know if you need any further assistance here?

Thanks,

Prashanth Are

MS Fabric community support

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query

[robbert-bi]

No, it was not solved.

[grazitti_sapna]

Hi @robbert-bi,

This is not achievable in MATRIX Visual but there is a work around if you go for Table visual.

Create a measure that returns a hex color code based on the Status:

StatusColor =
IF(
SELECTEDVALUE('YourTable'[Status]) = "Done",
"#D3D3D3", // Light Gray color for "Done"
"#FFFFFF" // White for others
)

Now you can apply conditional formatting, follow below steps:-

• Go to Format Pane > Cell Elements.
• Select "Status" column from the dropdown
• Find "Background color" and click on fx (function button).
• Choose "Field Value" and select your StatusColor measure.

🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
🔗 Curious to explore more? [Discover here].
Let’s keep building smarter solutions together!

[robbert-bi]

Hi. Thanks for your answer, but unfortunately this doesn't help because I need a matrix/pivot.

[grazitti_sapna]

Hi @robbert-bi, 

This functionality is still not available for Matrix view, you can upvote here for the idea.

Alternatively you can explore custom visuals, If you need full customization, use Deneb (a custom visual in Power BI) to design a pivot-like matrix with full row formatting.

🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
🔗 Curious to explore more? [Discover here].
Let’s keep building smarter solutions together!