Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I would like to have a dynamic dashboard.
The enduser wants to enter a begin and end date in his dashboard.
The original table is:
ID | startdate | enddate | hours |
1 | 2017-12-01 00:00:00.000 | 2017-12-01 02:00:00.000 | 2:00 |
2 | 2017-12-02 00:00:00.000 | 2017-12-02 01:00:00.000 | 1:00 |
3 | 2017-12-01 00:00:00.000 | 2017-12-02 01:00:00.000 | 25:00 |
4 | 2017-12-03 00:00:00.000 | 2017-12-03 01:00:00.000 | 1:00 |
5 | 2017-12-03 00:00:00.000 | 2017-12-03 03:15:00.000 | 1:00 |
6 | 2017-12-05 00:00:00.000 | 2017-12-05 03:15:00.000 | 2:00 |
7 | 2017-12-01 00:00:00.000 | 2017-12-01 03:15:00.000 | 0:15 |
8 | 2017-12-06 00:00:00.000 | 2017-12-06 04:30:00.000 | 1:00 |
9 | 2017-12-09 00:00:00.000 | 2017-12-09 04:30:00.000 | 2:00 |
10 | 2017-12-01 00:00:00.000 | 2017-12-01 04:30:00.000 | 1:30 |
When the enduser filters on begindate 2017-12-02 and enddate 2017-12-05 in his dashboard only the following rows must be visualized
ID | startdate | enddate | hours |
2 | 2017-12-02 00:00:00.000 | 2017-12-02 01:00:00.000 | 1:00 |
4 | 2017-12-03 00:00:00.000 | 2017-12-03 01:00:00.000 | 1:00 |
5 | 2017-12-03 00:00:00.000 | 2017-12-03 03:15:00.000 | 1:00 |
6 | 2017-12-05 00:00:00.000 | 2017-12-05 03:15:00.000 | 2:00 |
Startdate >= Selected_startdate AND endate <= Selected_enddate
Please do you want to add some screenshots or is it possible to add a downloadable PBX?
Solved! Go to Solution.
@BI_user,
Please download the PBIX file from the link below.
https://1drv.ms/u/s!AhsotbnGu1NogyDkrZposINAwiXU
Regards,
Lydia
@BI_user,
Please download the PBIX file from the link below.
https://1drv.ms/u/s!AhsotbnGu1NogyDkrZposINAwiXU
Regards,
Lydia
Thanks Lydia. This works well!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |