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 September 15. Request your voucher.
I have a data set with task that have bottom- and top-value, there can be several tasks on one day, but they never overlap and there can be 'space' between two task.
I would like to present them ala a stacked diagram, but I want to see where the various tasks lie in relation to each other. And if there is space between two tasks, it must be visible.
I have made a drawing of what I would like (or something that gives the same info), I have tried various stacked bar charts without success, I have also tried gantt without a useful result
Can anyone point me in the direction of a solution?
hello to acheive your goal
make 3 measure
the first is sum of top
the second is sum of bottom
the third is difference
after you do the measures
insert a stacked column chart and on x-axis put the week day and on y axis insert your 3 measure