The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
I am working with the following data:
ID | Country of Departure | Departure Date | Country of Arrival | Arrival Date |
1 | United Kingdom | 13/01/2022 | Tunisia | 15/01/2022 |
1 | Tunisia | 18/01/2022 | Chad | 23/01/2022 |
1 | Chad | 24/02/2022 | DR Congo | 27/02/2022 |
1 | DR Congo | 01/03/2022 | South Africa | 15/03/2022 |
2 | United Kingdom | 13/01/2022 | Spain | 15/01/2022 |
2 | Spain | 18/01/2022 | Chad | 23/01/2022 |
2 | Chad | 13/02/2022 | South Africa | 17/02/2022 |
3 | United Kingdom | 13/01/2022 | Spain | 15/01/2022 |
3 | Morocco | 18/01/2022 | Tunisia | 23/01/2022 |
3 | Tunisia | 26/01/2022 | Chad | 30/01/2022 |
3 | Chad | 16/02/2022 | South Africa | 19/02/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.
Thank you
Thank you but I'm particularly looking for a way to do this without using custom visuals.