Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
@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])
@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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
99 | |
76 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |