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 means when I click on the "Country" slicer, it will show the left pie chart, count distinct of the number of countries visited in a year, and when I click the "City" slicer, it will show the right pie chart, count distinct of the number of cities visited in a year.
Thank you.
5 Replies
Hi hkwan001 ,
You can try using the field parameter.Put the city and region into the parameter, then put the parameter into the legend field.
You can refer to:Let report readers use field parameters to change visuals (preview) - Power BI | Microsoft Learn [c326-cf39-488-7d8c]
Hope it helps!
Best regards,
Community Support Team_ Scott ChangIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
After putting the parameters in Legend, it does not group it by year.
Hi hkwan001 ,
This seems to be data related, can you share me a sample data.
Best regards,
Community Support Team_ Scott ChangHi,
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
