Forum Discussion
Filter visuals with position data to show only current position per tracking unit
- 5 years ago
Hi olepropell ,
I created a slicer button and a measure to do this.
Create a table for the slicer mine has the following values:
Values
All Values Latest Values Now create the following measure:
Latest_Values = VAR temp_table = SUMMARIZE ( ALL ( 'Table'[TrackerID], 'Table'[Date], 'Table'[Lat], 'Table'[Long] ), 'Table'[TrackerID], "DATE", MAX ( 'Table'[Date] ) ) RETURN SWITCH ( SELECTEDVALUE ( 'Period Selection'[Values] ), "All Values", 1, IF ( SELECTEDVALUE ( 'Table'[Date] ) = MAXX ( FILTER ( temp_table, 'Table'[TrackerID] = MAX ( 'Table'[TrackerID] ) ), [DATE] ), 1 ) )Now add this has filter on your visualizations and select all non blank vlaues
Result below and in attach PBIX file.
Hi, olepropell
Have MFelix’s reply helped you to solve this problem?
If so, would you like to mark his reply as a solution so that others can learn from it too?
If not, I suggest you to post some sample data or your test pbix file (without sensitive data) and we can help you in advance.
Thanks in advance!
How to Get Your Question Answered Quickly
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.