The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello,
Hope someone knows the answer! I use a gantchart and want see every step (codenr) in a proces. Some steps are at 1 day, the start and enddate ar the same.
In my visual I use for:
legend Codenr
Task: clientnr
Startdate: the startdate from a codenr
Duration: count days from startdate to enddate
I see now in the visual the codenr in time, but don't see de codenr when the startdate is the same as enddate. (even when I tried datetyp a day). Hope someone can help me, thank you!
thx for your reaction, I tried it but it still doesn't work...
Hi @Gretha28,
In your Gantt chart, the issue occurs because tasks with the same Start and End Date have a duration of zero, making them effectively invisible in the chart. Here is a solution to fix this issue:
Modify your duration measure so that it ensures a minimum duration of 1 day when the start and end dates are the same:
Duration =
VAR DaysDiff = DATEDIFF('Table'[Startdate], 'Table'[Enddate], DAY)
RETURN IF(DaysDiff = 0, 1, DaysDiff)
🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
🔗 Curious to explore more? [Discover here].
Let’s keep building smarter solutions together!
User | Count |
---|---|
11 | |
8 | |
6 | |
6 | |
5 |
User | Count |
---|---|
24 | |
14 | |
13 | |
9 | |
8 |