Forum Discussion
Showing latest one record on map visual
I have created the real time streaming dataset in power bi services which receives the real time data after every 5 minutes interval. I want to show live map visual which shows the country with bubble size reflects 'total cases'. Since the historical data analysis is enabled while showing the total on visual it's not showing the current moment or latest total instead it's showing total of all record uptill now gathered in realtime streaming dataset. what should i do to see only latest record detail on map visual. I have even used current date top n filter, top 1 by value current date as latest and apply the filter. But on that point map visual shows blank. what should I do to show only latest one record by all country.
HI Anonymous,
It is hard to direct setting filters on map visual to achieve your requirements. (you can try to write a measure formula to filter records and apply on the 'visual level filter' but power bi service not allow to create DAX formulas)
Maybe you can try to use date field to create a slicer with 'relative' mode to filter the last period of records.Regards,
Xiaoxin Sheng
1 Reply
HI Anonymous,
It is hard to direct setting filters on map visual to achieve your requirements. (you can try to write a measure formula to filter records and apply on the 'visual level filter' but power bi service not allow to create DAX formulas)
Maybe you can try to use date field to create a slicer with 'relative' mode to filter the last period of records.Regards,
Xiaoxin Sheng