Displaying week numbers on x-axis

[holgerson]

Hi experts,

I have a problem displaying week numbers on the x-axis. If I use a regular time hierarchy (based on dates), only dates or months are displayed on the x-axis. So, I decided to build a week number variable by myself in the form of YYYYWW (e.g. 201901), but when I use this integer variable as “continuous” the values which cannot be weeks (e.g. 201967) are also displayed on the axis. As “categorial” everything is sorted wrong and additionally you would have to scroll on the x-axis to have a look at the data.

Does anybody has ideas for a workaround to display week numbers continuously on the x-axis? This is how it looks like at the moment:

This is how it should look like:

If you need a pbix file with a minimum example dashboard I can provide it later.

Thanks in advance,

Holger

@Floribert 

[Anonymous]

Hello @holgerson 

Did you find a solution about the continuous/categorical x-axis ?

[Mariusz · Accepted solution]

Hi @holgerson 

For the sorting issue, please refer to the article below.

https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column

201967 seams little odd  and it should not happen if formatted correctly

FORMAT( TODAY()-10, "YYYYWW") -- will return 201952

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

[holgerson]

Thanks @Mariusz for your quick help. The nonsense weeks and sorting issue is now fixed. The only remaining issue is the scroll bar on the x-axis as now you can't choose between continuous/categorical in the new formatted week variable. Especially if the graph is only a small part of a dashboard and a large time range is chosen the user has to scroll much: