Forum Discussion
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
| yearmonth | Usage |
| 2022/04 | 0 |
| 2022/05 | 0 |
| 2022/06 | 0 |
| 2022/07 | 0 |
| 2022/08 | 0 |
| 2022/09 | 0 |
| 2022/10 | 0 |
| 2022/11 | 0 |
| 2022/12 | 0 |
| 2023/01 | 0 |
| 2023/02 | 0 |
| 2023/03 | 25 |
I want to highlight the last six months in green like this :
| yearmonth | Usage |
| 2022/04 | 0 |
| 2022/05 | 0 |
| 2022/06 | 0 |
| 2022/07 | 0 |
| 2022/08 | 0 |
| 2022/09 | 0 |
| 2022/10 | 0 |
| 2022/11 | 0 |
| 2022/12 | 0 |
| 2023/01 | 0 |
| 2023/02 | 0 |
| 2023/03 | 25 |
Ive tried using the cell elements tab and applying a measure to the background color using the "rules" format style but so far it is just returning like this.
Does anyone know any way of doing this? Am I missing something obvious?
Thank you in advance for any help.
My background formatting
My last six months measure:
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.
3 Replies
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.