Highlight or Background with different color for Last week data

[damit23183]

Hi,

I am working on one Line and Stack column chart where all data are arranged by startweekdate which every sunday. Please see picture below for more info.

As you can see above, chart is based on each sunday date now, what I want is to color or shadow with Greay background on highlighted week numbers which lastest week. 

All other columns values will be as it as just to highlight latest one.

Any idea on how to do it as I have never done that before?

Thanks

[amitchandak]

@damit23183 , On stacked visual, we can use conditional formatting, so that can not help

The only thing I can think of is having an additional line with marked. Where you can make the line width as 0 and the marker can highligh

New measure =

var _Sunday =  max(Date[Date]) - weekday(max(Date[Date]),1) +1

return

if( max(Date[Date])  =_Sunday , [Line Measure] , blank())

Use this as a line enable marker and make line width 0

[damit23183]

HI Amit,

Thanks for your solution but it's not working out as max date week i am getting is 31/7 instead of 10/09.

Thanks