Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowJuly 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more
Hi Experts,
I am using direct query and I have the table what I need for including Dates.
Can I add dropdown control saying that if user select the dates from that date control drop down it should show data after that date and following dates data only.
would it be possible?
Thank you
Solved! Go to Solution.
@Sudhakar510 , When you create a date slicer, there should be an option for after slicer , other than between , on that small down arrow
Thank You @amitchandak ,
while I was doing direct query, I am bringing as string format, instead date format.
Working now thank you
@Sudhakar510 , When you create a date slicer, there should be an option for after slicer , other than between , on that small down arrow
Hi @amitchandak
I can not see. Please could you let me know if I need to something to enable.
I mean not in filter section but would like to have in Drop down control as below so that user can select after date or below date if possible
Thank you
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
Join Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.
| User | Count |
|---|---|
| 27 | |
| 23 | |
| 18 | |
| 16 | |
| 15 |
| User | Count |
|---|---|
| 62 | |
| 44 | |
| 42 | |
| 37 | |
| 37 |