Forum Discussion

petermb72's avatar
petermb72
Helper IV
5 years ago
Solved

Conditional Formatting Based on a Table

I want to dislplay a Card and have the background show red if an occupancy level drops below a certain level.  The twist is that the locations have different thresholds of when they should be red.  H...
Need Help
  • PaulDBrown's avatar
    PaulDBrown
    5 years ago

    petermb72 

    With these sample tables:

     

     and this model:

     

    I've created the following measures:

    Occupancy = SUM(FactTable[Occupancy])
    Average Min Occ = AVERAGE('Min Occupancy'[Min Occupancy])

     

    and to format the cards:

    Conditional format = IF([Occupancy] < [Average Min Occ], 1, 0)

     

    Use this [Conditional format] measure to format the different elements of the card. For example:

    Backround

     

     

    Label

     

     and you get this

     

     

petermb72's avatar
petermb72
Helper IV
5 years ago

Also keep in mind I want to use a slicer to change the location and the card to display the correct backgound color, either Green or Red.  I will be doing other cards like this that will include Green Yellow Red depending on the % of a number.