Forum Discussion
Display weeks and years continuously
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 !
4 Replies
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.
Hi Anonymous ,
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.
😕
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.