cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sarjensystems1 Regular Visitor
Regular Visitor

Slicer Date Format

 

slicer Capture.PNG

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

 

3 REPLIES 3
Mvignesh53 Member
Member

Re: Slicer Date Format

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 Regular Visitor
Regular Visitor

Re: Slicer Date Format

hii @Mvignesh53 

 

slicer.PNG

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

Mvignesh53 Member
Member

Re: Slicer Date Format

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])

Helpful resources

Announcements
Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 240 members 2,651 guests
Please welcome our newest community members: