Forum Discussion
Conditional format based on indicator and value
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.
Thank you - I can see how this lets me use a measure to get to a True / False value for each. How would I integrate this into my chart, though? I don't see an option to use either of these for conditional formatting purposes if they aren't added to the Matrix, but adding them to the matrix ruins the formatting.
You are welcome. Please read up on how to use measures in conditional formatting.