Forum Discussion
DaniLP
3 years agoNew Member
Conditional format Card value based on the result on another Card
Hi all, I am unsure if its possible, but i tried looking around and can't seem to find a way. Im fairly new using and learning on my own pace PowerBI and had to say this so you know my level.....
- Anonymous3 years ago
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)
Anonymous
3 years agoNot applicable
Hi
I guess you posting all that code in the same measure.
You need to create each measure separadly in order to make it work.
If you want to learn more about measures in power BI you can watch the video bellow
https://www.youtube.com/watch?v=9VtaOAM2oOM&ab_channel=EnterpriseDNA
DaniLP
3 years agoNew Member
Ill have a look, thanks for your help! 🙂