Forum Discussion
Using the dates from date slicer in queries to filter data for visualization
Thank you for your response.
I explored the parameters option , however I haven't been able to figure how how parameters can be changed by the user and the report/dashboard to show the related data.
Essentially. I am trying to use start date and end date (enterable by user) to filter rows in query based on conditions eg. Start date = '2017-05-01' and End Date '2017-05-31' then I need my queries to use these dates as filters - select [Empname],[EmpHireDate],[EmpTermDate] from Employee where EmpHireDate <='2017-05-31' and ( EmpTermdate IS NULL or EmpTermdate > '2017-05-31')
this will give me the active employees in that date range.
I did find a workaround though, it was not quite hard to implement. Any ideas will be appreciated.
Good Day,
I am also in this same situation - that I need to make use of the
'start date' and 'end date' in my queries for different date fields.
I will appreciate a feedback on this work-around. Also, Power BI should make the slicer componts' values usable in underlying queries. This desirable feature should be impletemented.
Please keep me posted.
Good Day,
I am also in this same situation - that I need to make use of the
'start date' and 'end date' in my queries for different date fields.
I will appreciate a feedback on this work-around. Also, Power BI should make the slicer componts' values usable in underlying queries. This desirable feature should be impletemented.
Please keep me posted.
