Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

How to get visual like this

Can anybody tell me how to get following matrix visual?

 

  • Hi Anonymous ,

     

    What is their judgment condition for the rows marked in green? You can try to create a measure and use the condition formatting function. I did a test, refer to the following.

    colour = 
    var col = SELECTEDVALUE('Table'[Avg])
    return
    SWITCH(
        true(),
        col >0 ,"green",
        col = 0,"orange",
        col <0 ,"red")

     


    If the problem is still not resolved, can you further describe your needs, provide specific condition information and data models, I will answer for you as soon as possible. Looking forward to your reply.

     

    Best Regards,
    Henry


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

1 Reply

  • v-henryk-mstf's avatar
    v-henryk-mstf
    Icon for Community Support rankCommunity Support

    Hi Anonymous ,

     

    What is their judgment condition for the rows marked in green? You can try to create a measure and use the condition formatting function. I did a test, refer to the following.

    colour = 
    var col = SELECTEDVALUE('Table'[Avg])
    return
    SWITCH(
        true(),
        col >0 ,"green",
        col = 0,"orange",
        col <0 ,"red")

     


    If the problem is still not resolved, can you further describe your needs, provide specific condition information and data models, I will answer for you as soon as possible. Looking forward to your reply.

     

    Best Regards,
    Henry


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