I am working with the following data:
|ID||Country of Departure||Departure Date||Country of Arrival||Arrival Date|
|1||DR Congo||01/03/2022||South Africa||15/03/2022|
|2|| United Kingdom||13/01/2022||Spain||15/01/2022|
The data shows the route taken from the United Kingdom to South Africa by three individuals. For simplicity I have denoted each person with an ID of 1, 2 & 3. I'd like to create a flow chart in Power BI using the 'card visual' (no custom visuals). I'd like the flow chart to:
1. Show the countries that each person visited on their route from the United Kingdom to South Africa.
2. The number of days that each person spent in each country.
Any help would be greatly appreciated. Please let me know if you need more information.