Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Highlight Row in Table Based Off Date

I have a table with all of our transaction history, I have created a table visual by extracting the yearmonth from the TransactionDate and summed the Qtys with a measure.  My table looks like this  ...
Need Help
  • v-zhangti's avatar
    v-zhangti
    3 years ago

    Hi, Anonymous 

     

    You can try the following methods.

    Color Measure = IF(SELECTEDVALUE('Table'[yearmonth])>=EOMONTH(MAXX(ALL('Table'),[yearmonth]),-6)+1,"Green",BLANK())

    Is this the result you expect?

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-zhangti's avatar
v-zhangti
Community Support
3 years ago

Hi, Anonymous 

 

You can try the following methods.

Color Measure = IF(SELECTEDVALUE('Table'[yearmonth])>=EOMONTH(MAXX(ALL('Table'),[yearmonth]),-6)+1,"Green",BLANK())

Is this the result you expect?

 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    This is precisely what I need but how were you able to select the measure in the formatting pane? Mine will not let it be selected and highlights that box in red instead. 

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Really weird, it works perfect in your provided pbix file but in my report it just refuses to let me do it. Thank you anyway for your help. Marking this as the solution as it does indeed work just not in my instance for some reason. 

     

    thanks!