Forum Discussion

pradipir's avatar
pradipir
New Member
24 days ago
Solved

Date slicer

Hi, I need some help with Power BI. I want to use a Between Date Slicer and display the dates in this format: DD-MMM-YYYY Example: 01-Jan-2020 I don’t want to use the default dropdown/date format...
Actions
Activator
Anomaly Detector
Connectors
Digital Twin Builder
Event Schema Set
eventhouse
eventstream
General Comment
General Question
  • v-sathmakuri's avatar
    v-sathmakuri
    24 days ago

    Hi pradipir​ ,

    Thank you for reaching out to fabric community.

    Below steps will give the date in the format DD-MMM-YYYY.

    1. Add a Date column and set its Data type to Date.
    2. With the Date column selected, open Column tools -> Format -> Custom.
    3. Apply the following format: dd-MMM-yyyy
    4. Insert a Slicer visual and add the Date column to it.
    5. Open Format -> Slicer settings -> Options → Style -> Choose Date picker.
    6. Specify the required date range using the From Date and To Date fields.

    Thanks!!

jubinsoni's avatar
jubinsoni
Icon for Continued Contributor rankContinued Contributor
16 days ago

Hi pradipir​ ,

Building on ShivekMaharaj​  explanation: since the Between slicer's input boxes follow the viewer's locale, a common workaround is to keep the native Between slicer for selecting dates and show the chosen range in your format right next to it.

1. Create this measure:

Selected Date Range =
VAR _from = MIN ( 'Date'[Date] )
VAR _to   = MAX ( 'Date'[Date] )
RETURN
    FORMAT ( _from, "dd-mmm-yyyy", "en-US" ) & "  to  " &
    FORMAT ( _to,   "dd-mmm-yyyy", "en-US" )

2. Add a Card visual with this measure and place it directly above the slicer. The "en-US" locale argument keeps the month abbreviation as "Jan" for every viewer.

3. Optionally, turn off the slicer header and use the card as its label. Users then pick dates with the Between slicer and read the range as 01-Jan-2020 to 31-Dec-2020.

The selection still works as a true date filter, and users always see the dates in DD-MMM-YYYY.