Forum Discussion
Date input format for between dates slicer
Hi,
I need to convert the format of the dates to "Jan 1, 2000" instead of "m/dd/yyyy". I have already tried changing the Format to (mmmm d, yyyy) under Column tools. But the slicer still shows the same if "Between" option is selected as visual.
Can anyone help me here?
Thanks,
Hi Anonymous
This is by design, when you use a slicer to display or set a range of dates, the dates display in the Short Date format. The user's browser or operating system locale determine the date format. As such, it will be the display format no matter what the data type settings are for the underlying data or model.
You could, for example, have a long date format for the underlying data type. In this case, a date format such as dddd, MMMM d, yyyy would format a date in other visuals or circumstances as Wednesday, March 14, 2001. But in the date range slicer, that date displays in the slicer as 03/14/2001.
Displaying the Short Date format in the slicer ensures the length of the string stays consistent and compact within the slicer.
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Hi Anonymous ,
the date you see in the slicers is based on your PC localization. If you publish it in PBI Service, different users can see different format, based on their browser local. As far as I know, you can't force that all users will see it the same way.Hi Anonymous
This is by design, when you use a slicer to display or set a range of dates, the dates display in the Short Date format. The user's browser or operating system locale determine the date format. As such, it will be the display format no matter what the data type settings are for the underlying data or model.
You could, for example, have a long date format for the underlying data type. In this case, a date format such as dddd, MMMM d, yyyy would format a date in other visuals or circumstances as Wednesday, March 14, 2001. But in the date range slicer, that date displays in the slicer as 03/14/2001.
Displaying the Short Date format in the slicer ensures the length of the string stays consistent and compact within the slicer.
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
