Forum Discussion
Dynamically Slicing data sources by predefined date-ranges
I have a set of date-ranges defined by below table:
Name Length From To PI- (-1) 25 days? 11-03-2019 12-04-2019 PI-0 49 days? 23-04-2019 28-06-2019 PI-S 36 days? 28-06-2019 16-08-2019 PI-1 51 days? 16-08-2019 25-10-2019 PI-2 57 days? 25-10-2019 13-01-2020 PI-3 55 days? 13-01-2020 27-03-2020 PI-4 56 days? 27-03-2020 12-06-2020 PI-5 51 days? 12-06-2020 21-08-2020 PI-6 51 days 21-08-2020 30-10-2020
I want to use this definition to slice several data sources by the range
Data surce one - Allocation :
Date Weeknum Ressource Team Organisation Hours BacklogResource 20-05-2019 2019-21 XX Product YY 8 21-05-2019 2019-21 XX Product YY 8 22-05-2019 2019-21 XX Product YY 8 23-05-2019 2019-21 XX Product YY 8
Data source two - Timereg:
Case:Unique Id Case:Title Work package:Id Work package:Title Hours Done by Done date TOEDNLD-7 Project- Agile Team Member 5403 May - Agile Team Member 8 XX 31-05-2019 TOEDNLD-7 Project- Agile Team Member 5403 May - Agile Team Member 8 XX 30-05-2019 TOEDNLD-7 Project- Agile Team Member 5403 May - Agile Team Member 8 XX 29-05-2019
hi, obi
If you want to slice several data sources, you need to use Parameters in Power BI.
And it couldn't be used by slicer.
Slicer is based on the current data model, and the data had been loaded before.
https://www.mssqltips.com/sqlservertip/4475/using-parameters-in-power-bi/
https://docs.microsoft.com/en-us/power-bi/service-parameters
Best Regards,
Lin
1 Reply
hi, obi
If you want to slice several data sources, you need to use Parameters in Power BI.
And it couldn't be used by slicer.
Slicer is based on the current data model, and the data had been loaded before.
https://www.mssqltips.com/sqlservertip/4475/using-parameters-in-power-bi/
https://docs.microsoft.com/en-us/power-bi/service-parameters
Best Regards,
Lin