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
May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Submit your Data Story

Data Stories Gallery

Share your Data Story with the Community in the Data Stories Gallery.

Top Solution Authors