Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello everyone
I have a chart with stacked columns. I added a relative filter to the chart so it only shows data of the last 12 weeks. On the X axis I have my weeks in numbers 1,2,3,4,......, 52.
Due to the crossover of 2019 to 2020 my chart looks like in the added picture. How can I fix this so that de first weeks of the new year show at the right of the last weeks of last year?
Thanks in advance for the help!!
Solved! Go to Solution.
Hi @Anonymous ,
You could try to create a new column of "Year-Week" as a x-asix. It might be not implemented directly for the asix of week. Please follow the steps and check if it is what you want.
Year-Week = 'Table'[Date].[Year]&FORMAT(WEEKNUM('Table'[Date]),"0#")
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
you need to have year context added to get sorted correctly
How can I do this?
Hi @Anonymous ,
You could try to create a new column of "Year-Week" as a x-asix. It might be not implemented directly for the asix of week. Please follow the steps and check if it is what you want.
Year-Week = 'Table'[Date].[Year]&FORMAT(WEEKNUM('Table'[Date]),"0#")
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you. This works.
Is there a way that I make it so only the week number shows on the axis?
Hi @Anonymous ,
If you want to add only the week number into the axis, you could change the type to Categorical. However, the week number will be shown based on the number rahther than the actual date.
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks!
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |