Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Conditional formatting for cards visual

Hello All,   I need to do conditional formating on below cards. When I select Total potential saving from the slicer, the data from cards total weighted and total actual should have to gray out and...
Need Help
  • PhilipTreacy's avatar
    PhilipTreacy
    5 years ago

    Hi Anonymous 

     

    Download sample PBIX file

     

    You might want to adjust the color for the selected value, it's currently light blue when selected.  I wasn't sure what you meant by 'darker' - the background or the font?  I think it stands out more as it is.

    In the attached file are 3 measures to indicate if the associated card value is selected or not e.g.

    TAS Color = IF(ISFILTERED('Table'[Savings]), IF(SELECTEDVALUE('Table'[Savings])="Total Actual Savings",1,0),2)

     

    This is then used in a Conditioanl Formatting rule

     

    The color measures and rules are almost identical for the other 2.

     

    Regards

    Phil

PhilipTreacy's avatar
PhilipTreacy
Super User
5 years ago

Hi Anonymous 

 

Download sample PBIX file

 

You might want to adjust the color for the selected value, it's currently light blue when selected.  I wasn't sure what you meant by 'darker' - the background or the font?  I think it stands out more as it is.

In the attached file are 3 measures to indicate if the associated card value is selected or not e.g.

TAS Color = IF(ISFILTERED('Table'[Savings]), IF(SELECTEDVALUE('Table'[Savings])="Total Actual Savings",1,0),2)

 

This is then used in a Conditioanl Formatting rule

 

The color measures and rules are almost identical for the other 2.

 

Regards

Phil

walterdp's avatar
walterdp
Helper I
3 years ago

Hi PhilipTreacy 

 

I tried this but I could not find where to set the conditional formatting on a card

I found that you can do it in tables and matrices.