Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
jacknoble
Frequent Visitor

Bar charts apparently reverting to US date format when dataset is refreshed in workspace

Hi guys. 

 

This is something I've never seen before in many years of publishing reports, and it doesn't seem to make much sense. A colleague alerted me to the fact that when a particular report is published to a workspace, and its dataset refreshed, any bar graphs in the report then seem to revert to a US date format (we're UK-based). The rest of the report seems to remain in UK date format.

 

Here's how one of the bar charts should look. The x-axis displays a bar for each month:

jacknoble_0-1606235888059.png

 

It stays this way when published to a workspace, but when its dataset is refreshed in the online interface, it becomes this: 

 

jacknoble_1-1606235988785.png

 

While troubleshooting, I zoomed in one of the tiny bars displayed here and discovered that it is actually presenting a bar for each day of January up until the 12th day. This leads me to believe that the online interface is for some reason processing the x-axis in US date format (UK February 1st becomes US January 2nd, for example):

 

jacknoble_2-1606236271610.png

The values correlate (what is being displayed as January 2nd here correlates to what it should be showing for February 1st), so it seems like I'm onto something.

 

Another fascination is that while this UK/US date confusion seems to be the issue, other visuals on the report retain their UK date format when the dataset is refreshed: 

jacknoble_4-1606236952055.png

 

 

One thing that didn't work: grouping my months

My date values for the "month" column contain an arbitrary day value (01/01/2020 rather than 01/2020), because I'm pretty sure you have to have a day value for a date column in Power BI. I thought I could maybe circumvent this by creating a month group using the "group" feature to remove the day values entirely. When I use month "groups" for the x-axis instead, the report publishes normally once again, but when the dataset is refreshed, it becomes this: 

 

jacknoble_3-1606236551852.png

 

I'm pretty clueless as to why this is. It seems to only be able to find one value per year. 

 

A few other things of note: 

- My x-axis is not in date heirarchy mode. That doesn't work as an option because I have too many month values to display in that view, and they extend off the page. 

- My computer, browser(s) and Microsoft account are all set to UK date format. 

- I originally had the new zoom sliders feature enabled for graphs in this report. I found that they were causing some visual bugs in the data when published, so I disabled them. I even rebuilt my graph from scratch while troubleshooting this to see whether that might have been the cause. Has anyone heard of the zoom sliders causing permanent issues with reports? I know I'm clutching at straws here.

 

TLDR: 

My UK-date-format report's bar charts seem to change to US date format when the dataset is refreshed in the online interface. The rest of the report remains in UK date format. 

 

 

I would much appreciate any suggestions or advice, as this one has me stumped. Thanks!

1 ACCEPTED SOLUTION
jacknoble
Frequent Visitor

For anyone interested, I managed to solve this myself by changing the file's regional settings to US. 

View solution in original post

1 REPLY 1
jacknoble
Frequent Visitor

For anyone interested, I managed to solve this myself by changing the file's regional settings to US. 

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors