Don't miss your chance to take the Fabric Data Engineer (DP-600) exam for FREE! Find out how by attending the DP-600 session on April 23rd (pacific time), live or on-demand.
Learn moreNext 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
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.
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
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#
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.
Solved! Go to Solution.
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.
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.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Experience the highlights from FabCon & SQLCon, available live and on-demand starting April 14th.
| User | Count |
|---|---|
| 47 | |
| 44 | |
| 40 | |
| 20 | |
| 15 |
| User | Count |
|---|---|
| 70 | |
| 68 | |
| 32 | |
| 27 | |
| 25 |