Show multiple lines in single line per date

[miqueiasrlreis]

Hello again,

I have a requirement from user to develop some kind of chart to show, by equipment, all the orders assigned to it horizontally, similar to this I did in Excel

I tried most of the timeline visuals, Gantt Charts, but nothing is even similar to this. Multi-row Card was something almost there but still not what we need.

My structure is as follows  (hope the table dont get messy)

Equipment	Order ID	Planned Start Date	Planned  End Date	Actual Start Date	Actual End Date
1	ORDER ABC	27/02/2024 00:00:00	27/02/2024 08:00:00	27/02/2024 01:00:00	27/02/2024 09:00:00
1	ORDER XYZ	27/02/2024 08:00:00	27/02/2024 13:00:00	27/02/2024 09:00:00	27/02/2024 14:00:00
2	ORDER 123	27/02/2024 02:00:00	27/02/2024 07:00:00	27/02/2024 01:00:00	27/02/2024 08:00:00
2	ORDER 456	27/02/2024 12:00:00	27/02/2024 17:00:00	27/02/2024 09:00:00	27/02/2024 14:00:00

In other words, I need to show per equipment per line, everything that is going to be produced with dates/times.

Is there any way to do anything like this?
Thanks in advance for the help

[Daniel29195 · Accepted solution]

@miqueiasrlreis 

output

this is the following logic to obtain this : 

in power query , create the table as folllowing : 

you need per to create time column . 

create a dimtime table : 

and create a table :  dimtype with type as column name . 

then: create a measure : 

Measure 3 = 

var selectedtime =  SELECTEDVALUE(dimtime[time])
var selectedtype =  SELECTEDVALUE(dimtype[type])



var res = 
SWITCH(
    TRUE(),
    selectedtype =  "Planned" , 
        var orderid = 
        CALCULATE(
        MAXx(
        FILTER(
            data1,
            selectedtime >= data1[planned start time] && selectedtime <data1[planned end time]
        ),
        data1[Order ID]
        ),
        REMOVEFILTERS(dimtime)
        )
        return orderid,

    selectedtype =  "Actual" , 
    var orderid = 
    CALCULATE(
    MAXx(
    FILTER(
        data1,
        selectedtime >= data1[actual start time] && selectedtime <data1[actual end time]
    ),
    data1[Order ID]
    ),
    REMOVEFILTERS(dimtime)
    )
    return orderid

        
   
)

return res

let me know if this works. 

If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠

[Anonymous]

Hi @miqueiasrlreis 

PowerBI's built-in visual may not be able to meet your needs, if you want to achieve the same effect as your image, you can try using other custom visuals or using python scripts.

Best Regards,

Jayleny

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.