Forum Discussion

admin_xlsior's avatar
admin_xlsior
Post Prodigy
5 years ago
Solved

Conditional format with multi-row

Hello,   I was actually ask this before, but since the topic I replied is mark with Solved long time ago so I guess I better open a new one.  Basically I want to ask whether there is a trick to ha...
Tips and Tricks
  • Pragati11's avatar
    Pragati11
    5 years ago

    Hi admin_xlsior ,

     

    I don't think you can do this conditional formatting on multi-card visual.

    What you can try as a workaround is create 2 multi-card visuals:

    1. Multicard visual just having your top row data with data label colour as RED (visual level filter) 

       

    2. Multicard visual with rest of the other rows. (visual filter for other rows to be included) 

       

    3. Then place these multi-cards in such a way they look as one.
    4.  

       

    Let me know if this helps.

     

    Thanks,

    Pragati

Pragati11's avatar
Pragati11
Super User
5 years ago

Hi admin_xlsior ,

 

Are you looking for something like this?

If yes then you can go to format options --> Card title --> choose the required colour:

 

Thanks,

Pragati

admin_xlsior's avatar
admin_xlsior
Post Prodigy
5 years ago

Hi Pragati,

 

No, I only want the first row. So in your sample, I want the amount of "Jackets" to be Red.

 

Thanks,

  • Pragati11's avatar
    Pragati11
    Super User
    5 years ago

    Hi admin_xlsior ,

     

    I don't think you can do this conditional formatting on multi-card visual.

    What you can try as a workaround is create 2 multi-card visuals:

    1. Multicard visual just having your top row data with data label colour as RED (visual level filter) 

       

    2. Multicard visual with rest of the other rows. (visual filter for other rows to be included) 

       

    3. Then place these multi-cards in such a way they look as one.
    4.  

       

    Let me know if this helps.

     

    Thanks,

    Pragati

    • admin_xlsior's avatar
      admin_xlsior
      Post Prodigy
      5 years ago

      Hi Pragati,

       

      Thanks, smart ! ğŸ˜€

      Well done.

       

       

      • Pragati11's avatar
        Pragati11
        Super User
        5 years ago

        Hi admin_xlsior ,

         

        Yes sometimes we need to make smart moves to achieve things in Power BI. 🙂

         

        Thanks,

        Pragati