Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
We have a register of loan positions, with a table that contains where each article of date of arrival to date of departure. The columns of the tables are Item ID, date of arrival, date of departure, location.
Id_article | Arrival_date | Departure_date | Location |
00001 | 20/02/2016 | 23/02/2016 | New York, United States |
00002 | 20/02/2016 | 21/02/2016 | Paris, France |
00003 | 22/02/2016 | 22/02/2016 | Madrid, Spain |
00001 | 24/02/2016 | 26/02/2016 | Paris, France |
00002 | 24/02/2016 | 25/02/2016 | New York, EEUU |
How can we display on a map the location of all items on a date (dd / mm / yy) with an interactive screen filter that the user manages.
Thanks in advance for your tips.
Hi @sadotci,
Map visual support interactive by other visuals, you can add slicer which has the arrival date or departure date as source to filter the displayed location.
Regards,
Xiaoxin Sheng
Hi @v-shex-msft,
We have try this option but the slicer only permit filter by one column and we would need slicer between two columns. Do you know how to add slicer with user_date>arrival date and user_date<departure date.
Thanks
Hi @sadotci,
>>Do you know how to add slicer with user_date>arrival date and user_date<departure date.
You can simply create two slicer with these date column and modify these slicers' filter type to before and after.
Regards,
Xiaoxin Sheng
User | Count |
---|---|
94 | |
85 | |
78 | |
68 | |
63 |
User | Count |
---|---|
113 | |
99 | |
97 | |
64 | |
59 |