Forum Discussion

bensiqc's avatar
bensiqc
Helper I
4 years ago
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...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    4 years ago

    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.

  • bensiqc's avatar
    bensiqc
    4 years ago

    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))

bensiqc's avatar
bensiqc
Helper I
4 years ago

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. 

Ashish_Mathur's avatar
Ashish_Mathur
Super User
4 years ago

You are welcome.  Please read up on how to use measures in conditional formatting.