Forum Discussion
Need Help displaying duration based on 2 values
i want to thank you both for your help so far.
When i searched the internet for possible solutions i came across this custom visual
Gantt Chart By MAQ Software
And that is exactly what i need to fix the problem because i have a start date and sometimes an enddate and this visual displays it beautifully see the picture below
datediff can you duration and if you use end date relation then you can tell permits expiring in a month.
Can you share better sample data and sample output. If possible please share a sample pbix file after removing sensitive information.Thanks.
My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970
Here you can see some sample data
The type of permit is in column 'Soort vergunning' and 'Datum aangevraagd' is the date on which the permit has been requested and the column 'Datum verleend' is the column on which date the permit has been approved.
The column 'Vergunning geldig tot' is the date on which the permit expires
this visual isn't correct (i know) but what i want is that the Y-axis has the types of permits and the X-axis has the dates/weeks (start/end/duration) so that i can visualise the duration of the permits