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

Next up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. Register now

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
New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

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.

FabCon and SQLCon Highlights Carousel

FabCon &SQLCon Highlights

Experience the highlights from FabCon & SQLCon, available live and on-demand starting April 14th.

March Power BI Update Carousel

Power BI Community Update - March 2026

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