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.
HI,
I creating booking gantt that is used for viewing what days are already booked and which ones are free. Problem is that when I select date range in calendar filter, some bookings start before my minimal calendar date, so I must adjust start date in gantt to minimal calendar date, or gantt show dates before selected calendar date. I created measure for setting start date, but gantt start field is not accepting measure date as start date? Advise please, thanks
Solved! Go to Solution.
Hi @Anonymous,
In a Gantt chart, it is not available to add a measure into start date field.
In your scenario, you said the start date of Gantt chart was not filtered by the selected date from a slicer, right? Did you add date column from a separate calendar table into slicer, rather than the date column included in data table? If that is the case, please create a relationship between calendar table and data table based on date column.
Best regards,
Yuliana Gu
Hi @Anonymous,
In a Gantt chart, it is not available to add a measure into start date field.
In your scenario, you said the start date of Gantt chart was not filtered by the selected date from a slicer, right? Did you add date column from a separate calendar table into slicer, rather than the date column included in data table? If that is the case, please create a relationship between calendar table and data table based on date column.
Best regards,
Yuliana Gu
You are not 100% on the spot, but your answer helped me to create somethig I can use. Thank you very much 🙂
Is it possible that your share your new idea, I am having the same issue.
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 |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
129 | |
106 | |
106 | |
86 | |
72 |