Forum Discussion

Frequent Visitor

3 years ago

Solved

Set automatic marker for current week

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?

Tips and Tricks

Arul
3 years ago
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
3 years ago
sandraemma ,

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

Thanks,

Arul

3 Replies

Arul
Super User
3 years ago
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
  Frequent Visitor
  3 years ago
  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
    Super User
    3 years ago
    sandraemma ,
    
    put 0 in the measure in place of SUM('Query1'[Values])+1 and then set the secondary axis maximum to 1.
    
    Thanks,
    
    Arul