cancel
Showing results for
Did you mean:

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

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

4 REPLIES 4
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])

Helper I

@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?

Helper I

@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?

Helper I

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?

Announcements

#### New forum boards available in Real-Time Intelligence.

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

#### Power BI Monthly Update - May 2024

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

#### Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors