Forum Discussion

MarkSL's avatar
MarkSL
Helper V
7 years ago
Solved

Column chart by Week Number issue

Hi,   I have a Line and Clustered Column chart, which charts by sales by Week Number since 01/01/2018.  This was fine for all of last year, but now that we are into 2019, Week 1 & 2 from 2019 are o...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    7 years ago

    Hi MarkSL,

     

    You could place both [Year] column and [Week No] column onto shared Axis, then, drill down the chart to "Year-Week No" level.

     

    Best regards,

    Yuliana Gu

sturlaws's avatar
sturlaws
Resident Rockstar
7 years ago

Hi Mark,

 

you could try to add a start-of-the-week-date column in you date table. It could be achived with something like this, based on your date column:

 

start of week date = DATEADD(DateTable[date]; (WEEKDAY(DateTable[date];2)-1)*-1;DAY)

 

Use DateTable[start of week] on the axis, and you will have something that behaves nicely, although it will not show the weeknumber. You could put weeknum on the tooltip of the chart(but you need to treat it as a measure).

Regards,

Sturla