cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
veeru Frequent Visitor
Frequent Visitor

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

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

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

hi, @veeru 

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

11.JPG

 

Best Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
5 REPLIES 5
Mark_Timson Frequent Visitor
Frequent Visitor

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

@veeru 

 

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:

 Formatting.PNG

veeru Frequent Visitor
Frequent Visitor

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

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.Date.PNG

Community Support Team
Community Support Team

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

hi, @veeru 

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

11.JPG

 

Best Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
veeru Frequent Visitor
Frequent Visitor

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

Thanks for your solution.

 

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

 

Thanks,

Veereswar 

Community Support Team
Community Support Team

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

hi, @veeru 

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

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.