Not sure if it works with PowerBI, But with Excel if you set your Windows region settings to Canada it uses ISO8601 for dates. You can probably just change the options in Windows Control Panel so you don't need your entire system set to Canada because otherwise you'll be using Canadian English and all that.
There most likely is a setting somewhere to use a different date format in PowerBI if it doesn't look at the general Windows settings.
Not sure if it works with PowerBI, But with Excel if you set your Windows region settings to Canada it uses ISO8601 for dates. You can probably just change the options in Windows Control Panel so you don't need your entire system set to Canada because otherwise you'll be using Canadian English and all that.
There most likely is a setting somewhere to use a different date format in PowerBI if it doesn't look at the general Windows settings.
I don't remember if there's a global setting but there are settings for the colums and visuals, setting the date format to ISO 8601 is no problem.
Nothing wrong with Canadian English, eh?
😇🇨🇦😇
For windows if you go through control panel instead you can customise your region, so you can keep everything else and change just date format.