Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

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.

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

4 REPLIES 4
v-jayw-msft
Community Support
Community Support

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")

 

 1.PNG

 

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.

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.
Anonymous
Not applicable

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.

 

😕

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".

2.PNG

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

3.PNG

 

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.

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.
Anonymous
Not applicable

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

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.