Forum Discussion

EWBI's avatar
EWBI
Icon for Helper I rankHelper I
4 years ago
Solved

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

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.

 

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    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.

  • Anonymous's avatar
    Anonymous
    Not applicable

    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