Using the dates from date slicer in queries to filter data for visualization

Hi All, I am a newbie to Power BI, I need some help trying to build a map dashboard with date slicer. I need to be able to utilise the start and end dates selected in the date slicer and use them...

BIWhiz

Frequent Visitor

9 years ago

v-caliao-msft

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.