Set automatic marker for current week

[sandraemma]

Hello,

I have a Stacked column chart where I sort each item based on its week and I would like to add an automatic marker for todays week. 

I have used this formula to create a new column and  give each date the correct week.

Week = WEEKNUM('Query1'[MyDateColumn], 21)

I figured I need a line and stacked column chart and apply as the secondary axis this marker but I can't figure how to do this. Any advice? 

[Arul · Accepted solution]

@sandraemma ,

Try this measure in secondary axis of line and stacked column chart.

This week = 
   IF(WEEKNUM(MAX(('Query1'[MyDateColumn]),21)=WEEKNUM(TODAY()),SUM('Query1'[Values])+1,BLANK())

then enable the marker,

Thanks,

Arul

[Arul · Accepted solution]

@sandraemma ,

Try this measure in secondary axis of line and stacked column chart.

This week = 
   IF(WEEKNUM(MAX(('Query1'[MyDateColumn]),21)=WEEKNUM(TODAY()),SUM('Query1'[Values])+1,BLANK())

then enable the marker,

Thanks,

Arul

[sandraemma]

Thank you. Exacly what I have been trying to accomplish.

Is there a setting to get the marker at the bottom of the column? 

[Arul · Accepted solution]

@sandraemma ,

put 0 in the measure in place of SUM('Query1'[Values])+1 and then set the secondary axis maximum to 1.

Thanks,

Arul