Forum Discussion
Solved
Slicer Options for Datetime Format Parameter
I am building a report that uses three parameters for a SQL view in Direct Query mode: Start Date, End Date, and Site ID. The end goal is to allow the end user to select all three parameters to view ...
hello cody_c
i am not sure how your data looks like.
in my experience, since this is direct query, i did couple workaround to achieve the requirement.
here is an example..
1. 3fff... something is a direct query table.
2. then i summarize that direct query table. as you can see, the date is in datetime format.
3. then i created calculated column to simplify the datetime format into date format
4. create a relationship between those two table
5. plot into visual with summarize table as date slicer
i am not sure if this is a composite model, but here is what i did with direct query table and need to do a little change.
Hope this will help.
Thank you.
