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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
102 | |
84 | |
79 | |
70 |
User | Count |
---|---|
120 | |
110 | |
95 | |
82 | |
77 |