Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Dropdown date slicers ignore date formatting

Dropdown date slicers in reports keep defaulting back to long format after they are interacted with or you navigate back to a report page. This seems to happen in PBI Desktop and in the Service. Whether the column is calculated or not or Date or DateTime field doesn't seem to make any difference

Correct Format.PNGWrong format.PNG

Status: Needs Info
Comments
v-qiuyu-msft
Community Support

Hi @JonesTrac,

 

I'm trying to reproduce the issue but not succeed. Would you please share detail steps about "they are interacted with or you navigate back to a report page"? 

 

It would be possible if you could share a pbix file. 

 

Best Regards,
Qiuyun Yu 

Vicky_Song
Impactful Individual
Status changed to: Needs Info
 
JonesTrac
Frequent Visitor

Hi Qiuyun,

 

Please take a look at the video here showing the issue http://sendvid.com/v0glzwvz

 

It seems to happen most consistently when there are two date slicers on a page but I have had it with one slicer on a page. You set the slicer to June 2015 for example and switch pages. When you come back to the page the dropdown slicer displays 1st June 2015 00:00:00 GMT etc

v-qiuyu-msft
Community Support

Hi @JonesTrac,

 

Which Power BI desktop version do you run? Please update to the latest version then test again. 

 

If issue persists, please share a pbix file with some dummy data. 

 

Best Regards,
Qiuyun Yu