Date x-axis changes when uploading to power bi sevice

[ama209]

I have a report that shows monthly data (in the Sept 2022 format) in power bi desktop. Once I publish to PowerBI service, the date axis looks like its been change to a categorical data type. I have tried clearing the cache, refreshing the data, and republishing. Nothing has worked. I have also tried editing the report in power bi servie, but for some reason, I do not have the option to change from categorical to continuous data types in power bi service. Has anyone run into a similar issue and resolved it?

[v-yetao1-msft]

Hi @ama209 

If you delete the reports and republish from Desktop to Service , is the displayed date the same as the Desktop?

Best Regards,
Community Support Team _ Ailsa Tao

[ama209]

Hi @Alisa , unfortunately, deleting and republishing did not resolve the issue. Still searching for a long-term fix, but I've outlined an effective short-term fix, although not suited for all reporting situations.

Here is the link to the post:

Re: Recent change in X-axis behaviour to continuou... - Microsoft Power BI Community

[Anonymous]

Please see this post on how to replicate this bug, it is a bug.

X Axis continuous to categroical bug on publish - ... - Microsoft Power BI Community

[Anonymous]

I cant speak for this person, but i have the same issue. i tried to delete the report and republish and it did not help