Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

July 28 - August 9 | Final Round of the Power BI Dataviz World Championships. This is your chance. Learn more

Reply
AshlerK
Regular Visitor

Time Columns Visual One Time Column Locks into a Time

Hello,

 

I will have screenshots below displaying the issue. In the first screenshot I have trains by their number and by their line. Each train number hits both checkpoints coming in. I just need to see the time for each train# for when they hit checkpoint 5 and then hit checkpoint 1. I have these times in my two tables. One table is checkpoint 1 times and the other checkpoint 5.

 

When the two columns are put into the visual the leftmost column locks in a time but the other column properly displays all the different times that train number hit that checkpoint that day. Why won't both columnd show the unique times that the train hit the two checkpoints? My end result is to be a difference between the two columns but I cant even get there yet becasue BI is struggling to give me these two vlaues that are present on the table by category i'm visualizing. 

 

AshlerK_1-1653051139064.png

 

AshlerK_2-1653051172374.png

Same Train#, differnet trainID per train#, each ID represents a different day, and they each have a unique time value for when they hit the checkpoin for that unique trainID. Can;t get it to visualize that way though

AshlerK_0-1653051829041.png

 

AshlerK_1-1653051842030.png

 

 

 

AshlerK_3-1653051207866.png

 

Not sure why the visual wont display the time of arrival for checkpoint 1 and 5 whilst the unique train_ID is present as the train# isn't perfectly unique as it will go up and down the line as the day goes on. It does the same even when I remove the less unique train#

 

AshlerK_4-1653051312652.png

 

Meanwhile ID ending x1387 only has one row of data but it displays several.....need help as I am still intermediate user with Power Bi. 

 

 

1 ACCEPTED SOLUTION
AshlerK
Regular Visitor

Bump for assistance, still having trouble displaying both checkppint times for a filter that is the same at both of those checkpoints. In this screenshot it shows that the combined visual is just repeating the times for those unique TrainIDs down the line and then when it switches to a new TrainID it runs the same list of times....seems strange. 

 

AshlerK_0-1653055031361.png

 

View solution in original post

1 REPLY 1
AshlerK
Regular Visitor

Bump for assistance, still having trouble displaying both checkppint times for a filter that is the same at both of those checkpoints. In this screenshot it shows that the combined visual is just repeating the times for those unique TrainIDs down the line and then when it switches to a new TrainID it runs the same list of times....seems strange. 

 

AshlerK_0-1653055031361.png

 

Helpful resources

Announcements
Fabric Community Sticker Design Challenge Barcelona Carousel

Fabric Community Sticker Challenge - Barcelona 2026

If you love stickers, then you will definitely want to check out our community sticker challenge, Barcelona edition!

July Power BI Update Carousel

Power BI Monthly Update - July 2026

Check out the July 2026 Power BI update to learn about new features.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

Top Solution Authors