show date every 4 weeks in x axis

[thisiskl]

Hi community, 

I wanted to show dates in the x axis, say every four weeks, in ther x axis as below. How to proceed? 

Many thanks.

[thisiskl]

Hi @FreemanZ  this is a great tip to work out "the every four weeks" part. The thing is my client wanted to show 20 months of data without a scolling bar. And the x axis can't be continuous, because they wanted to leave the missing data points as blanks. The width of my chart can only fit in 12 months of data. I'm trying to figour out how to display 20 months of data without a scrolling bar. I thought if I show dates every four weeks, I could manipulate the width. But the client didn't want to see the week No., they wanted to see the specific date. 

[FreemanZ]

hi @thisiskl 

you may need to create a new grouping column in your Date table with the code below and pull the new column to your x-axis of your chart. 

WeekGroup =

VAR _WeekNum = WEEKNUM([Date], 2)

RETURN

SWITCH(

    TRUE(),

     _WeekNum<=4, "1-4W",

     _WeekNum<=8, "5-8W",

     _WeekNum<=12,"9-12W",

    _WeekNum<=16,"13-16W",

    _WeekNum<=20,"17-20W",

    _WeekNum<=24,"21-24W",

    _WeekNum<=28,"25-28W",

    _WeekNum<=32,"29-32W",

    _WeekNum<=36,"33-36W",

    _WeekNum<=40,"37-40W",

    _WeekNum<=44,"41-44W",

    _WeekNum<=48,"45-48W",

    "49-53W"

)

i tried and it worked like this:

hope you feel comfortable with this solution, otherwise you may try the easy but loose solution, like this:

https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-grouping-and-binning