Forum Discussion
Filter Pie Chart by Value Slicer
Hi, I want to merge these 2 pie charts into 1 pie chart. I want to only have 1 pie chart with a slicer for: "Country" and "City". The Details: Date/Year are the same for both pie charts. That me...
Hi hkwan001 ,
This seems to be data related, can you share me a sample data.
Best regards,
Community Support Team_ Scott Chang
Hi,
This is the data.
| City | Country | Date | City/Year | lat | lng |
| Florence | Italy | 20/12/2010 | Florence 2010 | 43.7714 | 11.2542 |
| Geneva | Switzerland | 20/12/2010 | Geneva 2010 | 46.2 | 6.15 |
| Interlaken | Switzerland | 20/12/2010 | Interlaken 2010 | 46.6863 | 7.8632 |
| Jungfraujoch | Switzerland | 20/12/2010 | Jungfraujoch 2010 | 46.5483 | 7.9806 |
| Lausanne | Switzerland | 20/12/2010 | Lausanne 2010 | 46.5333 | 6.6333 |
| Lucerne | Switzerland | 20/12/2010 | Lucerne 2010 | 47.0523 | 8.3059 |
| Lyon | France | 20/12/2010 | Lyon 2010 | 45.76 | 4.84 |
| Milan | Italy | 20/12/2010 | Milan 2010 | 45.4669 | 9.19 |
| Paris | France | 20/12/2010 | Paris 2010 | 48.8566 | 2.3522 |
| Pisa | Italy | 20/12/2010 | Pisa 2010 | 43.7167 | 10.4 |
| Rome | Italy | 20/12/2010 | Rome 2010 | 41.8931 | 12.4828 |
| Vatican City | Vatican City | 20/12/2010 | Vatican City 2010 | 41.9 | 12.4478 |
| Venice | Italy | 20/12/2010 | Venice 2010 | 45.4397 | 12.3319 |
| Frankfurt | Germany | 4/9/2015 | Frankfurt 2015 | 50.1136 | 8.6797 |
| Stuttgart | Germany | 5/9/2015 | Stuttgart 2015 | 48.7761 | 9.1775 |
| Ludenschied | Germany | 7/9/2015 | Ludenschied 2015 | 51.2191 | 7.6313 |
| Dortmund | Germany | 9/9/2015 | Dortmund 2015 | 51.5139 | 7.4653 |
| Ostrava | Czechia | 11/9/2015 | Ostrava 2015 | 49.8356 | 18.2925 |
| Olomouc | Czechia | 16/9/2015 | Olomouc 2015 | 49.5939 | 17.2508 |
| Prague | Czechia | 20/9/2015 | Prague 2015 | 50.0833 | 14.4167 |
| Budapest | Hungary | 12/10/2015 | Budapest 2015 | 47.4983 | 19.0408 |
| Bratislava | Slovakia | 25/10/2015 | Bratislava 2015 | 48.1447 | 17.1128 |
| Brno | Czechia | 31/10/2015 | Brno 2015 | 49.1953 | 16.6083 |
| Krakow | Poland | 9/11/2015 | Krakow 2015 | 50.0614 | 19.9372 |
| Auschwitz | Poland | 10/11/2015 | Auschwitz 2015 | 50.0274 | 19.202 |
| Warsaw | Poland | 22/11/2015 | Warsaw 2015 | 52.2167 | 21.0333 |
| Frydek-Mistek | Czechia | 30/11/2015 | Frydek-Mistek 2015 | 49.6881 | 18.3536 |
| Vienna | Austria | 19/12/2015 | Vienna 2015 | 48.2083 | 16.3731 |
| Salzburg | Austria | 21/12/2015 | Salzburg 2015 | 47.7972 | 13.0477 |
| Mondsee | Austria | 22/12/2015 | Mondsee 2015 | 47.8567 | 13.3517 |
| Innsbruck | Austria | 23/12/2015 | Innsbruck 2015 | 47.2683 | 11.3933 |
| Ljubljana | Slovenia | 25/12/2015 | Ljubljana 2015 | 46.05 | 14.5167 |
| Zagreb | Croatia | 28/12/2015 | Zagreb 2015 | 45.8 | 15.95 |
| Maribor | Slovenia | 29/12/2015 | Maribor 2015 | 46.55 | 15.6333 |
| Graz | Austria | 30/12/2015 | Graz 2015 | 47.0749 | 15.4409 |
| Graz | Austria | 1/1/2016 | Graz 2016 | 47.0749 | 15.4409 |
| Munich | Germany | 2/1/2016 | Munich 2016 | 48.1372 | 11.5755 |
| Berlin | Germany | 4/1/2016 | Berlin 2016 | 52.5167 | 13.3833 |
| Ostrava | Czechia | 6/1/2016 | Ostrava 2016 | 49.8356 | 18.2925 |
| Basel | Switzerland | 7/1/2016 | Basel 2016 | 47.5606 | 7.5906 |
| Strasbourg | France | 7/1/2016 | Strasbourg 2016 | 48.5833 | 7.7458 |
| Frankfurt | Germany | 9/1/2016 | Frankfurt 2016 | 50.1136 | 8.6797 |
| Athens | Greece | 7/12/2016 | Athens 2016 | 37.9842 | 23.7281 |
| Sounion | Greece | 10/12/2016 | Sounion 2016 | 37.6578 | 24.0152 |
| Tirana | Albania | 11/12/2016 | Tirana 2016 | 41.33 | 19.82 |
| Shkoder | Albania | 13/12/2016 | Shkoder 2016 | 42.0667 | 19.5 |
| Podgorica | Montenegro | 15/12/2016 | Podgorica 2016 | 42.4397 | 19.2661 |
| Kotor | Montenegro | 16/12/2016 | Kotor 2016 | 42.4254 | 18.7712 |
| Stari Bar | Montenegro | 18/12/2016 | Stari Bar 2016 | 42.1 | 19.1 |
| Belgrade | Serbia | 20/12/2016 | Belgrade 2016 | 44.8167 | 20.4667 |
| Sofia | Bulgaria | 23/12/2016 | Sofia 2016 | 42.6979 | 23.3217 |
| Ruse | Bulgaria | 26/12/2016 | Ruse 2016 | 43.8445 | 25.9539 |
| Bucharest | Romania | 27/12/2016 | Bucharest 2016 | 44.4 | 26.0833 |
| Brasov | Romania | 28/12/2016 | Brasov 2016 | 45.65 | 25.6 |
| Sofia | Bulgaria | 1/1/2017 | Sofia 2017 | 42.6979 | 23.3217 |
| Thessaloniki | Greece | 1/1/2017 | Thessaloniki 2017 | 40.6403 | 22.9356 |
| Athens | Greece | 2/1/2017 | Athens 2017 | 37.9842 | 23.7281 |
| Madrid | Spain | 11/5/2017 | Madrid 2017 | 40.4167 | -3.7167 |
| Barcelona | Spain | 15/5/2017 | Barcelona 2017 | 41.3825 | 2.1769 |
| Andorra la Vella | Andorra | 17/5/2017 | Andorra la Vella 2017 | 42.5 | 1.5 |
| Valencia | Spain | 19/5/2017 | Valencia 2017 | 39.4699 | -0.3763 |
| Malaga | Spain | 21/5/2017 | Malaga 2017 | 36.7194 | -4.42 |
| Gibraltar | UK | 22/5/2017 | Gibraltar 2017 | 36.1324 | -5.3781 |
| Sevilla | Spain | 24/5/2017 | Sevilla 2017 | 37.39 | -5.99 |
| Lisbon | Portugal | 26/5/2017 | Lisbon 2017 | 38.7452 | -9.1604 |
| Braga | Portugal | 28/5/2017 | Braga 2017 | 41.5333 | -8.4167 |
| Porto | Portugal | 29/5/2017 | Porto 2017 | 41.1495 | -8.6108 |
| Toledo | Spain | 2/6/2017 | Toledo 2017 | 39.8628 | -4.0273 |
| Amsterdam | Netherlands | 11/5/2019 | Amsterdam 2019 | 52.3667 | 4.8833 |
| Zurich | Switzerland | 11/5/2019 | Zurich 2019 | 47.3786 | 8.54 |
| Keukenhof | Netherlands | 13/5/2019 | Keukenhof 2019 | 52.2697 | 4.5469 |
| Zaanse Schans | Netherlands | 14/5/2019 | Zaanse Schans 2019 | 52.4729 | 4.8219 |
| Delft | Netherlands | 15/5/2019 | Delft 2019 | 52.0119 | 4.3594 |
| The Hague | Netherlands | 15/5/2019 | The Hague 2019 | 52.0767 | 4.2986 |
| Brussels | Belgium | 16/5/2019 | Brussels 2019 | 50.8333 | 4.3333 |
| Bruges | Belgium | 18/5/2019 | Bruges 2019 | 51.2089 | 3.2242 |
| Ghent | Belgium | 18/5/2019 | Ghent 2019 | 51.0543 | 3.7174 |
| Dinant | Belgium | 19/5/2019 | Dinant 2019 | 50.26 | 4.9101 |
| Luxembourg | Luxembourg | 19/5/2019 | Luxembourg 2019 | 49.6106 | 6.1328 |
| Antwerp | Belgium | 20/5/2019 | Antwerp 2019 | 51.2206 | 4.4003 |
| Dortmund | Germany | 21/5/2019 | Dortmund 2019 | 51.5139 | 7.4653 |
| Cologne | Germany | 22/5/2019 | Cologne 2019 | 50.9422 | 6.9578 |
| Hamelin | Germany | 23/5/2019 | Hamelin 2019 | 52.1083 | 9.3622 |
| Hannover | Germany | 23/5/2019 | Hannover 2019 | 52.3744 | 9.7386 |
| Düsseldorf | Germany | 24/5/2019 | Düsseldorf 2019 | 51.2311 | 6.7724 |
| Helsinki | Finland | 23/12/2019 | Helsinki 2019 | 60.1756 | 24.9342 |
| Tallinn | Estonia | 23/12/2019 | Tallinn 2019 | 59.4372 | 24.745 |
| Jagala | Estonia | 26/12/2019 | Jagala 2019 | 59.4499 | 25.1785 |
| Pärnu | Estonia | 28/12/2019 | Pärnu 2019 | 58.3844 | 24.4989 |
| Riga | Latvia | 28/12/2019 | Riga 2019 | 56.9475 | 24.1069 |
| Turaida | Latvia | 28/12/2019 | Turaida 2019 | 57.1805 | 24.8405 |
| Jūrmala | Latvia | 1/1/2020 | Jūrmala 2020 | 56.9471 | 23.6168 |
| Kaunas | Lithuania | 2/1/2020 | Kaunas 2020 | 54.9 | 23.9333 |
| Šiauliai | Lithuania | 2/1/2020 | Šiauliai 2020 | 55.9349 | 23.3137 |
| Vilnius | Lithuania | 2/1/2020 | Vilnius 2020 | 54.6833 | 25.2833 |
| Trakai | Lithuania | 4/1/2020 | Trakai 2020 | 54.6333 | 24.9333 |
| Riga | Latvia | 5/1/2020 | Riga 2020 | 56.9475 | 24.1069 |
| Frankfurt | Germany | 1/7/2022 | Frankfurt 2022 | 50.1136 | 8.6797 |
| Cologne | Germany | 2/7/2022 | Cologne 2022 | 50.9422 | 6.9578 |
| Amsterdam | Netherlands | 3/7/2022 | Amsterdam 2022 | 52.3667 | 4.8833 |
| Zaandam | Netherlands | 5/7/2022 | Zaandam 2022 | 52.4417 | 4.8422 |
| Zaanse Schans | Netherlands | 5/7/2022 | Zaanse Schans 2022 | 52.4729 | 4.8219 |
| Dortmund | Germany | 6/7/2022 | Dortmund 2022 | 51.5139 | 7.4653 |
| Dresden | Germany | 7/7/2022 | Dresden 2022 | 51.05 | 13.74 |
| Pirna | Germany | 9/7/2022 | Pirna 2022 | 50.9622 | 13.9403 |
| Leipzig | Germany | 10/7/2022 | Leipzig 2022 | 51.3333 | 12.3833 |
| Nuremberg | Germany | 10/7/2022 | Nuremberg 2022 | 49.4539 | 11.0775 |
| Munich | Germany | 12/7/2022 | Munich 2022 | 48.1372 | 11.5755 |
| Starnberg | Germany | 12/7/2022 | Starnberg 2022 | 47.9972 | 11.3406 |
| Geltendorf | Germany | 15/7/2022 | Geltendorf 2022 | 48.1222 | 11.0278 |
| Landsberg | Germany | 15/7/2022 | Landsberg 2022 | 48.0528 | 10.8689 |
| Fussen | Germany | 16/7/2022 | Fussen 2022 | 47.5667 | 10.7 |
| Salzburg | Austria | 17/7/2022 | Salzburg 2022 | 47.7972 | 13.0477 |
| Mondsee | Austria | 18/7/2022 | Mondsee 2022 | 47.8567 | 13.3517 |
| Berchtesgaden | Germany | 19/7/2022 | Berchtesgaden 2022 | 47.6314 | 13.0042 |
| Hallstatt | Austria | 20/7/2022 | Hallstatt 2022 | 47.5622 | 13.6493 |
| Augsburg | Germany | 21/7/2022 | Augsburg 2022 | 48.3717 | 10.8983 |
| Paris | France | 18/5/2023 | Paris 2023 | 48.8566 | 2.3522 |
| Colmar | France | 19/5/2023 | Colmar 2023 | 48.0817 | 7.3556 |
| Colmar | France | 19/5/2023 | Colmar 2023 | 48.0817 | 7.3556 |
| Bresiach | Germany | 20/5/2023 | Bresiach 2023 | 48.0348 | 7.5836 |
| Zurich | Switzerland | 23/5/2023 | Zurich 2023 | 47.3786 | 8.54 |
| Vaduz | Liechtenstein | 24/5/2023 | Vaduz 2023 | 47.1415 | 9.5215 |
| Milan | Italy | 25/5/2023 | Milan 2023 | 45.4669 | 9.19 |
| Bergamo | Italy | 26/5/2023 | Bergamo 2023 | 45.695 | 9.67 |
| Venice | Italy | 27/5/2023 | Venice 2023 | 45.4397 | 12.3319 |
| Rome | Italy | 28/5/2023 | Rome 2023 | 41.8931 | 12.4828 |
| Rome | Italy | 28/5/2023 | Rome 2023 | 41.8931 | 12.4828 |
| Vatican City | Vatican City | 29/5/2023 | Vatican City 2023 | 41.9 | 12.4478 |
| Helsinki | Finland | 30/12/2023 | Helsinki 2023 | 60.1756 | 24.9342 |
| Poorvo | Finland | 31/12/2023 | Poorvo 2023 | 60.3932 | 25.6653 |
| Helsinki | Finland | 1/1/2024 | Helsinki 2024 | 60.1756 | 24.9342 |
| Ivalo | Finland | 2/1/2024 | Ivalo 2024 | 68.6576 | 27.5397 |
| Kirkenes | Norway | 3/1/2024 | Kirkenes 2024 | 69.7271 | 30.0451 |
| Saariselka | Finland | 4/1/2024 | Saariselka 2024 | 68.4197 | 27.41 |
| Kakslauttanen | Finland | 5/1/2024 | Kakslauttanen 2024 | 68.3342 | 27.3348 |
| Rovaniemi | Finland | 6/1/2024 | Rovaniemi 2024 | 66.5028 | 25.7285 |