Forum Discussion

sandraemma's avatar
sandraemma
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  g...
Need Help
Tips and Tricks
  • Arul's avatar
    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's avatar
    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

     

Arul's avatar
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's avatar
    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's avatar
      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