Critical Requirement - Display date format in DD/MM/YYYY in Power BI using SSAS Live connection

[Anonymous]

Hi All,

We have a critical requirement of showing dates in DD/MM/YYYY in Power BI Date Range Slicer. As we are using SSAS live connection, the modelling features of Power BI Desktop gets disabled.

Currently dates are stored in MM/DD/YYYY format in date type column in SQL database pulled to Power BI through SSAS cubes. As soon as we are trying to convert the format in MM/DD/YYYY in SSAS or SQL database it automatically converts the column type to text. And Power BI needs date type column in date range slicer as input.

Please suggest any workarounds to accomplish this.

[v-piga-msft · Accepted solution]

Hi @Anonymous ,

By my tests, we could change the date format to be DD/MM/YYYY in SSAS Tabular and it will still keep this format in power bi for live connection.

Do you have the issue for date between slicer in power bi? From my test, the date format DD/MM/YYYY could show correct in list slicer but incorrect in between slicer. 

If it is convenient, could you share the screenshot for your scenario so that we could understand it better?

Best  Regards,

Cherry

[Anonymous]

@v-piga-msft ,

Thanks for your reply. Yeah we also need this format in Date range slicer and not in list slicer, So as soon as you convert your date into DD/MM/YYYY format, the column type becomes text and date range slicer accomodates only date type column. Therefore in date range slicer it is showing as MM/DD/YYYY format. And list slicer can accomodate text type column also.

[vanessafvg]

@Anonymous  can i ask why it needs to be in that date format?

[Anonymous]

@vanessafvg ,

Actually the customer requirement is to show in DD/MM/YYYY format and this format is possible only with text column type, but if you go through our conversation chain, date range slicer only accomodates date type column. So somehow it automatically converts this to MM/DD/YYYY format.

Please suggest if any further updates on this.