Solved: Date format in slicer

rogletree · ‎10-07-2020

I am making a visual using date as a slicer.

When I have the data type set to Date, it shows up in the slicer like this:

When I have the data type set to Text, it shows up in the slicer like this:

I like the second way better, but I'd rather keep the data type as Date rather than Text. Is there a way to keep the data type as Text but have it displayed as the other way?

CNENFRNL · ‎10-07-2020

Hi, @rogletree , you may want to set date format this way,

Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension!

DAX is simple, but NOT EASY!

View solution in original post

CNENFRNL · ‎10-07-2020

Hi, @rogletree , you may want to set date format this way,

Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension!

DAX is simple, but NOT EASY!

rogletree · ‎10-07-2020

That did it, thank you! I was looking in the wrong spot for changing the format.

Daviejoe · ‎10-07-2020

Apologies your date format would be "mm/dd/yyyy"

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Daviejoe · ‎10-07-2020

Have you tried changing the format of your date column to "dd/mm/yyyy" or to your preferred formatting?

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Date format in slicer

Helpful resources

Microsoft Fabric Learn Together

Power BI Monthly Update - April 2024

Fabric Community Update - April 2024

How to Get Your Question Answered Quickly