Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I have a dates table with all calendar values, and another table project with the occupancy of the person . I wanted to display the people availability of the person from a particular start date to end date.
My approach is creating two slicer one for start date,one for end date and then a matrix to display the name and availability.
Example,
if A is allocated to project from 1-march 2024 to 15-june 2024
Then if selected date is 1-feb to 30 march then availability for feb should be 100% and march should be 0%
If selected date is 15may to 30june then may should be 100%, june 50%
Solved! Go to Solution.
Doesn't that solve the problem?
Phil
Proud to be a Super User!
Doesn't that solve the problem?
Phil
Proud to be a Super User!
No it doesn't
Hi @Drake1002
Can't you set the slicer style to 'Between' so that you can use a single slicer to set the earliest and latest dates?
Regards
Phil
Proud to be a Super User!
Yes I can
User | Count |
---|---|
97 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
59 |