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

v-henryk-mstf's avatar
v-henryk-mstf
Community Support
4 years ago

Hi bensiqc ,

 

Whether the advice given by Ashish_Mathur  has solved your confusion, if the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly. If not, please point it out.


Looking forward to your feedback.


Best Regards,
Henry