How to change the date format in Power BI date Slicer, which is coming after date selection?

[Anonymous]

How to change the date format in Power BI date Slicer, which is coming after date selection.By default it is taking US format(03/30/2019) need to change in this format 30-MAR-19.

[Mark_Timson]

@Anonymous 

I think this is done by clicking the date column you want to change the format of going to the modelling tab on the report view then selecting "date". You can change the format then to the specified format you are interested in.

See below:

 

[Anonymous]

Hi Mark,

I have already done that in SSAS Cube, it is coming correct in the chart but not in the Date Slicer.

See the attached screen shot.

[v-lili6-msft · Accepted solution]

hi, @Anonymous 

Based on my test, the date format of date slicer is based on local computer region setting not the format of the current filed.

Best Regards,

Lin

[Anonymous]

Thanks for your solution.

If i need to control the date on Mobile devices, then how can we acchived that.

Thanks,

Veereswar 

[v-lili6-msft]

hi, @Anonymous 

Date format of slicer in power bi serivce is based on the language setting of the browser.

and Power BI mobile apps use the device settings to determine date format of slicer.

Best Regards,

Lin