cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Rajan244
Helper I
Helper I

How to handle the duplicate Timestamps in route map?

I am using route map, everything is working fine, even the route is accurate.

 

Only issue before filtering specific path map look somthing like 

 

Rajan244_0-1664542978186.png

 

I am guessing the issue is Timestamp, I am giving 1 to n rank for each path as timestamp. 

table view of map

 

Rajan244_1-1664543144951.png

 

Any idea how can I make unique ? 

I was thinking make it decimal according to group like 1.1, 1.2,1.3, 2.1,2.2,2.3. just need littlebit guidance how can i do using DAX? 

 

Moreover, is huge and in Json can't show your clear table, but still I have try to add

 

NoContainer_NoEventsLatLon
1HLXU111Dub-Rot53.33306-6.24889
1HLXU111Rot-Kara51.92254.47917
2HLXU111Dub-Rot52.84235105-6.16893985
2HLXU111Rot-Kara51.796750514.429912263
3HLXU111Dub-Rot50.55237595-5.79583915
3HLXU111Rot-Kara51.5332783.430639
4HLXU111Dub-Rot50.061667-5.715889
4HLXU111Rot-Kara49.727861-1.940028
5HLXU111Dub-Rot50.08522105-5.4050098

 

1 REPLY 1
lbendlin
Super User
Super User

Please provide sanitized sample data that fully covers your issue.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Helpful resources

Announcements
Vote for T-Shirt Design

Power BI T-Shirt Design Challenge 2023

Vote for your favorite t-shirt design now through March 28.

March 2023 Update3

Power BI March 2023 Update

Find out more about the March 2023 update.

March Events 2023A

March 2023 Events

Find out more about the online and in person events happening in March!

Top Solution Authors