Forum Discussion
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...
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
Does this allow us to choose a location as a slicer rather than the date?