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

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!