Forum Discussion
Recent change in X-axis behaviour to continuous axis for categorical chart
Community SupportHi, Anonymous
According to my test, I selected "continuous" on the X-axis in Power BI Desktop, but after publishing to Power BI Service, it still displays "continuous" in the Editing view.
If my understanding is inconsistent with your question, you can provide us with corresponding screenshots so that we can help you better.
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi Aniya,
Here I will be using the "Retail Analysis Sample" PBIX file.
After downloading the file, opening it, creating a new page, I make a Line Chart view with:
X Axis: Store -> "OpenDate" as a date hierarchy,
Y-Axis: Sales -> "Average Unit Price"
Legend: Item -> "Category"
I then drill down, "expand all", to the lowest level of data. This is what it looks like in desktop:
Notice the X-Axis is continuous:
Then I publish the report. This is what it looks like in the service:
Notice the X-Axis is now categorical, and broken. There is no way to change it back in the service.
This is a bug, please look to resolve. I will look to make a separete post about this also.
Cheers,
QF