Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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 |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
84 | |
66 |