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

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

arun_1047 — Mon, 09 Apr 2018 21:06:34 GMT

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

Oct Version

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

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

giorgilomidze — Tue, 10 Apr 2018 12:58:40 GMT

make sure that format is date

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

arun_1047 — Tue, 10 Apr 2018 18:50:01 GMT

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

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

giorgilomidze — Wed, 11 Apr 2018 15:20:28 GMT

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.

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

Anonymous — Mon, 16 Apr 2018 15:34:29 GMT

Same issue. Thanks for posting.

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

Anonymous — Tue, 17 Apr 2018 16:24:53 GMT

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

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

arun_1047 — Wed, 18 Apr 2018 03:32:49 GMT

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"