Forum Discussion
Solved
Conditional format based on indicator and value
I'm having trouble trying to set up conditional formatting in a matrix visual that should do this: If the date is 1 day before today (I have set up an indicator for this but would prefer it not b...
Hi,
Try these measures
Measure for Yellow = and(today()-min(data[date])=1,[measure]>300)
Measure for red = and(today()-min(data[date])>=2,[measure]>300)
Hope this helps.
The issue with this solution is that it results in two measures. I've read up quite a bit and I don't see a way to apply conditional formatting of one type to one table based on multiple measures. I was able to take what you gave me and combine it into one measure, though. So thanks again.
FORMAT = if(and(today()-min(TABLE[Date])>=2,[Packages]>300),1,if(and(today()-min(TABLE[Date])=1,[Packages]>300),2,0))
Hi,
Try these measures
Measure for Yellow = and(today()-min(data[date])=1,[measure]>300)
Measure for red = and(today()-min(data[date])>=2,[measure]>300)
Hope this helps.