Column charts not showing same layout in service as they are in desktop

[kieranb123]

Hello,

I have a report with two column charts. In the desktop they are showing the year, month and day with the columns for each day.

When I publish them, it shows completely different (by year). I have tried removing and re adding the visual, but the same issue persists.

Any ideas? Images attached

Desktop (how I want it): 

Service:

[Anonymous]

Hi @kieranb123 

Have you use the drill up/down which may cause the issue?

If not, please check the date hierarchy settings in your visualization tool or service. Ensure that the date column is correctly recognized as a date field and that the hierarchy is set to year, month, and day. Verify that the date column is being used as the x-axis in your column charts.

And if this can't help, please delete the semantic model in service and re-publish the pbix in desktop.

Best Regards

Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.