AUS-DOH-Safety-and-Quality / PowerBI-SPC

A free and open-source PowerBI custom visual for SPC charts
GNU General Public License v3.0
44 stars 15 forks source link

Can't update Date format in Chart #306

Open csumm828 opened 4 months ago

csumm828 commented 4 months ago

We are using this visual in multiple reports, but one issue that keeps popping up is when a user needs MM/DD/YYYY, changing the locale to en-US doesn't change it. It still shows DD/MM/YYYY. We tried different formats for the data type, but that didn't appear to have an impact. Is there some other requirement to be able to use the US format in the visual?

shauneccles commented 3 months ago

Have you tried to change the date format of the column in the data model? You should be able to select it and change the format to the desired locale.

image

csumm828 commented 3 months ago

Good morning,

Thank you for the update and the suggestion. We did try to update the formats in the desktop client for the column / field in the data model as well and that doesn't appear to have an impact. I have attached some screenshots to show you what we are seeing on our end.

Date Filter Date Format Date Format in SPC Chart Date Format Selections in SPC Chart

Here's a breakdown of the screenshots, we have a date format in the Power BI desktop client that aligns with your recommendations, that's set. We also have a filter leveraging that date format and that appears as expected. We have also chosen the right date format in the SPC Visual menu. Where it breaks is if you look at the date format at the bottom of the SPC Chart, instead of MM/DD/YYYY like it is everywhere else, its showing DD/MM/YYYY. All of our reports use either MM/DD/YYYY or MM-DD-YYYY or MM-YYYY. So we would need to see if it would be possible to update this somehow. I'm hoping it something simple, but I would love to get your thoughts.

Thanks in advance for any guidance or insight you can provide.