Forum Discussion
Compress x-axis
The cause is a bit hard to find without seeing your data model.
Could you post the data view of your table?
It looks like the issue is that the column that you are using for the "X-Axis" in the line chart is not a date column.
You need something like this:
2024/06/01
2024/06/02
...
formatted as "date type".
It looks like your column consists of the days of June ("1","2",...) so Power BI cannot know that it is a date. It will then just write them out in the visual without a way to group them together. It is the same as if you make a visual with "a", "b", "c" as values for the x-axis.
But it would be easier to diagnose when we could see your data model. You can blur the sensitive parts.
Please check that your date column is of data type "date" and not "text".
The cause is a bit hard to find without seeing your data model.
Could you post the data view of your table?
It looks like the issue is that the column that you are using for the "X-Axis" in the line chart is not a date column.
You need something like this:
2024/06/01
2024/06/02
...
formatted as "date type".
It looks like your column consists of the days of June ("1","2",...) so Power BI cannot know that it is a date. It will then just write them out in the visual without a way to group them together. It is the same as if you make a visual with "a", "b", "c" as values for the x-axis.
But it would be easier to diagnose when we could see your data model. You can blur the sensitive parts.
Please check that your date column is of data type "date" and not "text".