Slicer Date Format

[sarjensystems1]

Hii...

I am using slicier visual...

1)i need the date format as 01-Aug-2019 and 31-Aug-2019...but the date format is not changing in the required format even  after changing the date format in the modelling section...

2)How to dynamically select the current month  dates in the above  slicer??

Thank you

[Anonymous]

Hi,

1. To address your first question, The Formula you should use for the new column 

2. To address your second question, the Formula is 

2. Selection_Value_Month := MONTH(SELECTEDVALUE(Date[Transaction_Date]))

1. Date_Column:= DATEVALUE(FORMAT(Date[Transaction_Date],"dd-MMM-yyyy"))

[sarjensystems1]

hii @Anonymous 

while selecting list option and dropdown options in slicer...date format will change from modelling section and as well as from your formula..but while selecting between option the date format is not changing

[Anonymous]

Hi,

The Format shown in the "Between" Type is System Generated can cannot be changed.

However, I can suggest a Workaround. If you keep reducing the Height of the Slicer at one point it shows nothing but the Slider. Now You need to Create two measures for First_Date and Last_Date and put them on the top of the Slicer on the left and the Right respectively. Use the Format Function that I have specified to resolve the Date in the Format thats needed.

First_Date:= FIRSTDATE(Date[Date])
Last_Date:= LASTDATE(Date[Date])