Display weeks and years continuously

[Anonymous]

Hi,
Does someone have ever customized a x-axis (on a histogram) and used continuous vs categorical type ?
I need to show the distribution (y-axis) of a product on a weekly basis (x-axis) and I would like the chart to be continuous, so we don't have to scroll.
It works if we are showing only one year (see image below) but if I want to add another year, it will automatically show it in a categorical type.

If you've already done this in the past, can you please share your experience? 🙂
Many thanks for your help !

[v-jayw-msft]

Hi @Anonymous ,

How about create a CALENDAR table and add a column like "year-weeknum" then create a relationship between CALENDAR table and fact table and use this column as x-axis of the visual?

CALENDAR = CALENDARAUTO()

yearweek = FORMAT('CALENDAR'[Date],"YYYY-WW")

 

Best Regards,

Jay

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi @v-jayw-msft ,

Thank you for your answer. I tried this way but I still have two problems :

- It shows as 2019-1, 2019-10, 2019-11, [...] 2020-1, ... instead of 2019-1 2019-2, ... and I can't "sort by column" because it won't let me (the icon is grey)

- I still have to scroll from left to right and I would like to see every weeks in one shot.

😕

[v-jayw-msft]

Hi @Anonymous ,

If you want it shows all weeks even if there's no data on that week, just select "Show items with no data".

You can change category width under Format -> X-axis, but based on my test it can't be narrowed unlimitly.

Best Regards,

Jay

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Thank you @v-jayw-msft 

I tried several things and it's not exactly how I want it to but I will keep looking. 

Thanks for your help.

Regards