Power BI Embedded - Set date format only without changing locale

[surajshashidhar]

Hallo,

I am trying to set only the date format to "yyyy-MM-dd" and keep locale as German de-DE. But it seems like fine grain changes to locale(keep decimal/thousand separator to German but have dateFormat as "yyyy-MM-dd") does not work.

Is there a way to use required date Format such that same is visible in calendar date picker, whilst maintaining german locale?

I have provided the embedded settings that i used and also screenshot of filter pane from dashboard.

settings: {
            panes: {
               filters: {
                   visible: true
               },
               pageNavigation: {
                   visible: true,
                   position: models.PageNavigationPosition.Left // make page navigation towards left
               },
            },
            localeSettings: {
                language: "en", // Language (English)
                formatLocale: "de-DE" // Locale for date format (switzerland/sweeden/china/korea etc uses yyyy-MM-dd)
                // danish : dd-mm-yyyy | korean : yyyy-mm-dd | sweeden : yyyy-mm-dd
            },
            dateFormat: "yyyy-MM-dd", // this does not work and date always depends on formatLocale
            layoutType: models.LayoutType.Custom, // Use custom layout
            customLayout: {
                displayOption: models.DisplayOption.FitToWidth // Set display option to Fit to Width
            }
        },

[v-nmadadi-msft]

Hi @surajshashidhar,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the community members for the issue worked. If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Thanks and regards

[v-nmadadi-msft]

Hi @surajshashidhar ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If our responses has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thanks and regards

[v-nmadadi-msft]

Hi @surajshashidhar,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. If some other troubleshooting step has worked please let us know and accept that as solution, This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[v-nmadadi-msft · Accepted solution]

Hi  @surajshashidhar ,
Thanks for reaching out to the Microsoft fabric community forum.

Please try @GilbertQ's valuable suggestions, in addition to their point you can try to change the format using

Format pane. Change the Format options to the required date order and test if that is working for you.

If you find this post helpful, please mark it as an "Accept as Solution" and consider giving a KUDOS.
Thanks and Regards

[GilbertQ]

Hi @surajshashidhar 

What happens if you go into the semantic model and create a custom format string for your date column and upload that, could that potentially work?

Use custom format strings in Power BI Desktop - Power BI | Microsoft Learn

[surajshashidhar]

Hello @GilbertQ , Yes i tried this solution, but the slicers date (with between filter) only changes as per locale settings. It cannot be changed otherwise. Even in local settings there is no way to separate date format from decimal/thousand separator settings