cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

Date Slicer Function (Relative,Before,After and Between) missing in March 2018 PBI Desktop

Hello,

I could not able to see the Date  Slicer function  (Relative,Before,After and Between) with March 2018 PBI Desktop version whereas the same i could replicate in the Oct 2017 version

 

Source: SSAS

Connection: Live

 

March Version

Date Slicer- March 2018.png

 

Oct Version

Date Slicer- Oct 2017.png

 

Scenario:

Connect SSAS Live Connection.

Drag and Drop the Slicer . Add Date Column.

Select the Drop Down near to the clear selections

 

March Version : 2.56.5023.1043 64-bit (March 2018)

Report Server Version 1.2.6660.39920 (Build 15.0.2.389),

 

6 REPLIES 6
Highlighted
Resolver I
Resolver I

Re: Date Slicer Function (Relative,Before,After and Between) missing in March 2018 PBI Desktop

make sure that format is date

Highlighted
Helper I
Helper I

Re: Date Slicer Function (Relative,Before,After and Between) missing in March 2018 PBI Desktop

It is a date Format. The same is working Oct 2017 Version but not in MArch 2018 Version

Highlighted
Resolver I
Resolver I

Re: Date Slicer Function (Relative,Before,After and Between) missing in March 2018 PBI Desktop

Date relative.PNG

Can you share your dataset preferably PBI?
I dont have any problems with it. I transferd all 2017 october files to 2018 february files with no problems. It shows all options: Between, Before, After, List, Dropdown, Relative.

Highlighted
Post Prodigy
Post Prodigy

Re: Date Slicer Function (Relative,Before,After and Between) missing in March 2018 PBI Desktop

Same issue.  Thanks for posting.

Highlighted
Helper I
Helper I

Re: Date Slicer Function (Relative,Before,After and Between) missing in March 2018 PBI Desktop

Its because you are using a live connection. date is not detected in a slicer if its live

Highlighted
Helper I
Helper I

Re: Date Slicer Function (Relative,Before,After and Between) missing in March 2018 PBI Desktop

The same functionality is working in Oct 2017 version. As long as the datatype is "Date" it should work. In my case, the Calendar Date Data type is "Date"

Helpful resources

Announcements
May 2020 Community Highlights

May 2020 Community Highlights

It’s time for another PBI Community recap!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Galleries

Galleries

Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!

Top Solution Authors
Top Kudoed Authors