Row background color change from one source in a Matrix based on the value of another data source.

[EWBI]

Hi there!

I'm really flustered and hoping someone can put me on the right path.

I have a matrix that visualizes 1 data source but also linked to a column of another data source.

In a matrix you can't use Color Formatting for the Rows. But I need "User Name" row to highlight a user red or green based on

if there is a value in the Date completed column of the second data source. The Common link between the 2 sources is their User ID.

Please see my Image for reference.

[v-eqin-msft]

Hi @EWBI ,

Could you tell me if my reply helps you? If it does, kindly Accept it as the solution. More people will benefit from it.

Best Regards,
Eyelyn Qin

[v-eqin-msft · Accepted solution]

Hi @EWBI ,

To my knowledge, there is no option available to apply conditional formatting to Row/Column fields in Matrix visual:

It's only

Ideas similar with what you expect have been submitted in Ideas, please vote them up and you can add comments.Hopes Power Bi will implement this in nearby future.

https://ideas.powerbi.com/ideas/search-ideas/?q=conditional%20formatting%20for%20matrix

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