Weird Date Format on Clustered Column Chart X-Axis

Hi Anonymous,

It doesn't appear to be a browser issue as I get the same behaviour in Chrome or Edge.

I have checked other reports and it is happening in all of them, so it looks like a broader issue rather than an isolated case. What I find most strange is that the formatting is fine in the desktop application on all reports, it is only the service where this is a problem, so something is happening after publishing to make this happen. To confirm, were you succesfully able to download the 'Format Test' file I shared through google drive so you could see it working locally?

I was wondering if it is a configuration issue I have made, but I don't see how it can be. Regardless of the configuration, the format behaviour after selecting an option from the slicer is inconsistent, so it definitely seems like a bug:

• My thinking was firstly around the X-Axis type (continuous or categorical), but it has to be continuous as we would want to show gaps in the data.
• Due to this type, I was wondering if there was an issue with my date table in the model (maybe you can spot something?), but it all seems to be in order, with the correct (Date) data type and PBI identifying a date hierarchy.
• The final thing is the slicer is using a date hierarchy, whereas the chart x-axis is using just date. So potentially there is something PBI doesn't like here, but it still doesn't account for the inconsistent behaviour and why it works on desktop but not service.

As a final point, I have noticed that depending on the region where the service is hosted, there can be differences (when bugs are fixed, some regions seem to see the fix before others). So for clarity, I am UK based. If you are in a different location, perhaps this is why you are not able to replicate the behaviour?