Solved: Numeric Slicer for Direct Query

KWelsh8144 · ‎08-23-2018

I'm trying to put a the date in the slicer while using direct query. I was hoping to be able to use the 'between' option rather than just list or dropdown. Is this not possible to do with direct query? It's working when I import the data, but it's not working using direct query.

Thanks.

Anonymous · ‎08-23-2018

Hey @KWelsh8144

I just ran a test using DirectQuery and the moment I brought a date field into a slicer it defaulted to the Between type.

What version of Power BI are you running? I am running August 2018.

-Parker

View solution in original post

Anonymous · ‎08-23-2018

Hey @KWelsh8144

I just ran a test using DirectQuery and the moment I brought a date field into a slicer it defaulted to the Between type.

What version of Power BI are you running? I am running August 2018.

-Parker

KWelsh8144 · ‎08-23-2018

@Anonymous thanks so much for the quick reply! i had to just change the data type - it worked!

v-chuncz-msft · ‎08-24-2018

@KWelsh8144,

By the way, you may help accept the solution above. Your contribution is highly appreciated.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.