change x axis label for a graph with calendar week over several years

[Anonymous]

Hello,
I want to create a lineStackedColumnComboChart with calendar weeks over severale years. So I have created a new column in which the year and the calendar week are shown as numbers.
Then I have the problem that the x-axis adds the missing values of the calendar weeks.

Then i found a function that determines the calendar week. Now i need the possibility to change my x axis with the values of the other column:

I hope you understand my problem and that someone can help me.

Thanks!

[Anonymous]

Good morning

Are you using a date table?

If you don't want to change too much, check the data type for the date. You can change the type.

Also, you can use a data table for the date of everything, but you need to use relationships.

Search Date Dimension Tables, there are many.

Thank you, I'm a Spanish student, forgive my mistakes,

[Anonymous]

Hi @Anonymous,
thanks for your answer. I have created such a date table. Unfortunately, the result is the same. When I display the calendar week with the year (two values in the common x-axis), I have no auto scale.

With only the calendar week in the common a-axis I have an auto scaling but it combines the values of the different years in one calendar week.

Is there no possibility in the X-axis to display the calendar week for several years in a row with auto scaling?

[v-yingjl]

Hi @Anonymous ,

Maybe use the filter of this visual to filter the value is not 0.

Best Regards,
Yingjie Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hello @v-yingjl ,

thank you for your tip. Unfortunately, this also does not work in relation to the calendar year and calendar week.

[Anonymous]

Hi @v-yingjl ,

thank you for your tip. Unfortunately, this also does not work in connection with the calendar year and calendar week.

[Greg_Deckler]

Maybe, try switching your axis to categorical instead of continuous?

[Anonymous]

then i don't have auto scaling for filtering with different number of data sets.