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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.