Forum Discussion
Conditional format Card value based on the result on another Card
Then you will need to create a measure with those filters.
Create the ones bellow
# Items = --Bellow put the column refering to the items being summed SUM('table'[column]) Card 1 Measure = CALCULATE( [# Items], DATESINPERIOD('Date'[Date], TODAY() , -1000 , DAY ) ) Card 2 Measure = CALCULATE( [# Items], status[status] in {"Not Started","On Hold","In progress"} ) Conditional formating measure = VAR _carddiff = [Card 2 Measure] - [Card 1 Measure] RETURN IF( _carddiff <> 0, 1, 0)
Hi,
Yes, you can use conditional formating on a card background based on any measure you want. Just click on the fx icon shown bellow. Then add create the measure you want to be analyzed and add a rule to it.
In your example, maybe create a measure like this:
Conditional formating measure =
VAR _carddiff = [Measure Card 1] - [Measure Card 2]
RETURN
IF( _carddiff <> 0, 1, 0)
This will return 1 if the card measures have diferent values
Then add a rule the if the value is 1 has some colour
Hope it helps.
Kind regards,
José
Please mark this answer as the solution if it resolves your issue.
Appreciate your kudos! 🙂
Hi, thanks for the reply.
I am unsure in how to make the quick measure with what appears in the Card1/2.
Card1 value is basically the total, but to the card i apply some filters in order to obtain the result.
So card1 would be total items, up to today.
and card2 would be total items up to today, not complete.
But, as mentioned, both Card1 and 2 are showing values based on filteres applied to the visual.
Is your method requiring that the calculations are made without filters in the visual? or how i can add the card code so i can complete the formula you suggested for the measure?
thanks in advance!
Yes, in this case you will need to pass the filters to the measures.
Could you share your pbix file so i can provide and example?
Can't share the file, but hopefully screens below help:
Card1 filters:
Card2 filters:
same as above+
Card1 is displaying a 5, and Card2 is displaying a 2 in this case.
is this enough? thanks 🙂
Then you will need to create a measure with those filters.
Create the ones bellow
# Items = --Bellow put the column refering to the items being summed SUM('table'[column]) Card 1 Measure = CALCULATE( [# Items], DATESINPERIOD('Date'[Date], TODAY() , -1000 , DAY ) ) Card 2 Measure = CALCULATE( [# Items], status[status] in {"Not Started","On Hold","In progress"} ) Conditional formating measure = VAR _carddiff = [Card 2 Measure] - [Card 1 Measure] RETURN IF( _carddiff <> 0, 1, 0)