Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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 |
---|---|
16 | |
13 | |
12 | |
11 | |
10 |
User | Count |
---|---|
19 | |
16 | |
14 | |
11 | |
9 |