Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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 woul...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

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's avatar
Anonymous
Not applicable
6 years ago

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.

 

😕

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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's avatar
      Anonymous
      Not applicable
      6 years ago

      Thank you Anonymous 

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

      Thanks for your help.

      Regards