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
Tobias106
Helper I
Helper I

Week & Year in x-axis as type continuous

Hello,

 

In the X-axis I want to show the calender week and the year combined, e.g. 01/2021, 02/2021, 12/2021, 01/2022, 07/2022 ...

 

I already created a calendar table.

 

When I combine cw and year with

"CW/YEAR", WEEKNUM(([Date]),21) & "/" & YEAR([Date])

 

... the diagramm changed to the type "category" and is still not anymore "continuous". Why I need "continous" is because I don't want to have the scroll bar in the x-xis, when I reduce the width of the diagramm.

 

Thanks,

 

Tobias

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@Tobias106 , You can get continuous axis with number and date only

 

Create a column like this and use

 

Week Year = Year([Date])*100 +weeknum([date])

View solution in original post

4 REPLIES 4
amitchandak
Super User
Super User

@Tobias106 , You can get continuous axis with number and date only

 

Create a column like this and use

 

Week Year = Year([Date])*100 +weeknum([date])

@amitchandak thank you very much. But unfortunetly I need your help again 😊

 

Now I have, by using your help, a graph which shows in the x-axis

 

a) A continous column chart for 2021 with 52 columns; the x-axis is named 202100 under the first colum and under the last column 2021050 

b) A column chart for 2022 with 30 columns; the x-axis is named 202200 under the first colum and under the last column is no label.

 

Maybe you can help me agian, that would be great 😊.

 

To a) Can I display more labels? Only the first and last is not to much, if you have 52 data points

To b) Can I display the last label, 202230?

 

And: Can I show instead, e.g. 202150 -> 50/2021? So, it's is easier to read?

 

Thank you in advance @amitchandak 

 

 

 

@amitchandak thank you very much. But unfortunetly I need your help again 😊

 

Now I have, by using your help, a graph which shows in the x-axis

 

a) A continous column chart for 2021 with 52 columns; the x-axis is named 202100 under the first colum and under the last column 2021050 

b) A column chart for 2022 with 30 columns; the x-axis is named 202200 under the first colum and under the last column is no label.

 

Maybe you can help me agian, that would be great 😊.

 

To a) Can I display more labels? Only the first and last is not to much, if you have 52 data points

To b) Can I display the last label, 202230?

 

And: Can I show instead, e.g. 202150 -> 50/2021? So, it's is easier to read?

 

Thank you in advance @amitchandak 

 

 

 

@amitchandak ok, my fault. I had a mistake in the additional colum ("&" instead of "*").

 

Now I have, by using your help, a graph which shows in the x-axis

 

a) A continous column chart for 2021 with 52 columns; the x-axis is named 202100 under the first colum and under the last column 2021050 

b) A column chart for 2022 with 30 columns; the x-axis is named 202200 under the first colum and under the last column is no label.

 

Maybe you can help me agian, that would be great 😊.

 

To a) Can I display more labels? Only the first and last is not to much, if you have 52 data points

To b) Can I display the last label, 202230?

 

And 1: Can I show instead, e.g. 202150 -> 50/2021? So, it's is easier to read?

And 2: There is much space between the 2 charts (between the chart with the 52 columns for 2021 and the chart with the 30 columns for 2022). Any idea to reduce the space?

 

Thank you in advance @amitchandak 

 

 

 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.