cancel
Showing results for
Did you mean:
Helper III

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.  Here are the table examples and what I would like for an outcome:

 Location Min Occupancy North .90 South .75 East .65 West .50

I would have a slicer for the Location and then a card that would show the current Occupancy rate.  The Card would also show a background color of Red if it drops below the Min. Occupancy.  For an example

North would show a card with Red if the Occupancy was at .88 but none of the other locations would be red, they would be green if they were at .88.  West would be green at .55 but East would be red.  How do I setup up the card to use the different thresholds for the different locations to determin the background color?

1 ACCEPTED SOLUTION
Super User

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

In doing so, you are also helping me. Thank you!

Proud to be a Super User!

4 REPLIES 4
Super User

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

In doing so, you are also helping me. Thank you!

Proud to be a Super User!

Helper III

Does this allow us to choose a location as a slicer rather than the date?

Super User

Sure...

I've attached the sample PBIX file for your reference

In doing so, you are also helping me. Thank you!

Proud to be a Super User!

Helper III

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.

Announcements

Power BI T-Shirt Design Challenge 2023

Vote for your favorite t-shirt design now through March 28.

Power BI March 2023 Update

Find out more about the March 2023 update.

March 2023 Events

Find out more about the online and in person events happening in March!

Top Solution Authors
Top Kudoed Authors