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 have been asked to create a gantt chart to go by day of the week. What we are looking for is to show how many days a guest stays based on the day of the week they arrive and type of surgery.
So in the graphic below - those people admitted on Monday that have surgery 1 have an average stay of 3 days. If the same surgery on Wednesday, their average stay is 2 days.
If they have surgery 2 and arrive Monday, their average stay is 4 days and if they have the same surgery on Thursday, they also stay 4 days.
They really want it in this gantt format and not in a matrix. Is this possible?
Solved! Go to Solution.
Hi kattlees,
Based on my test, I find that there is no grant chart could achieve this goal currently. You could use “Gantt Chart By MAQ” from market, you will get below result
Data sample might be similar to below, create two measures
Measure 4 = MIN(gantt[ds]) Measure 3 = MIN(gantt[ds])+MIN(gantt[days])-1
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
hi kattlees, were you able to create the room schedule dashboard? Would you please share the sample dashboard with me? Thanks!!
Hi kattlees,
Based on my test, I find that there is no grant chart could achieve this goal currently. You could use “Gantt Chart By MAQ” from market, you will get below result
Data sample might be similar to below, create two measures
Measure 4 = MIN(gantt[ds]) Measure 3 = MIN(gantt[ds])+MIN(gantt[days])-1
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
107 | |
93 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |