Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Adding highlight to a column in visual based on date

I would like the column in this matrix visual where the reporting end of week is the most recent one passed to be highlighted in yellow.  For example, today is 2/24 so 2/19 would be the most recent p...
Need Help
  • v-alq-msft's avatar
    v-alq-msft
    5 years ago

    Hi, Anonymous 

     

    You may modify the 'Calendar' table as below.

     

    Calendar = 
ADDCOLUMNS(
    CALENDARAUTO(),
    "EndofWeek",
    var d =[Date]
    return
    MAXX(
        FILTER(
            CALENDARAUTO(),
            YEAR([Date])*100+WEEKNUM([Date])=YEAR(d)*100+WEEKNUM(d)
        ),
        [Date]
    )
)

     

     

    Result:

     

     

     

    Best Regards

    Allan

     

    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
5 years ago

One thing i noticed about that calendar:  one of the days is after the after the end-of-week, every week.

 

v-alq-msft's avatar
v-alq-msft
Community Support
5 years ago

Hi, Anonymous 

 

You may modify the 'Calendar' table as below.

 

Calendar = 
ADDCOLUMNS(
    CALENDARAUTO(),
    "EndofWeek",
    var d =[Date]
    return
    MAXX(
        FILTER(
            CALENDARAUTO(),
            YEAR([Date])*100+WEEKNUM([Date])=YEAR(d)*100+WEEKNUM(d)
        ),
        [Date]
    )
)

 

 

Result:

 

 

 

Best Regards

Allan

 

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