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

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

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    4 years ago

    You are welcome.