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.

VijayP's avatar
VijayP
Icon for Community Champion rankCommunity Champion
5 years ago

Anonymous 

You can Create a measure using in The Field Value option in Conditional Formatting

if(Selectedvalue(Date)=26 Feb 2021 - 7 , "Red", "")
(for this =26 Feb 2021 - 7

you need to build dynamic field based on the behaviour of your data).

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

I tried this but it won't let me select reportingEndofWeek as a field - maybe because it's a date.