Create filter from many columns

[DifferentName]

Hi teams, 

So I am using a dataset from this link at kaggle https://www.kaggle.com/datasets/thedevastator/global-religious-demographics 

This is how the data looks like.

From the .csv file we can see that there are about 75 column of different religion. I am creating a data visualisation like this 

The slicer for years work well but the slicer for religion selection not working. I will be using all the 75 column of different religion. Is there a way I can create that slicer 

[DifferentName]

Hi thanks so much for the help I have tried both of the method that you suggest but I encounter a small problem.

1. Method 1: Field Parameter for 75 Region

I have tried created 75 Field Parameter and I noticed that it does not change the map once I filtered it. 

2. Method 2: Unpivot other column

I have tried that method and it seems all the country are bubbled in the wrong places.

If perhaps I shared you my power BI can you take a look of it. I have create two pages, one using unpivot method and another is using field parameter method.

https://wormhole.app/yR6kv#RP6wT1tXKm6UWpjTtLzemw 

[PijushRoy · Accepted solution]

Hi @DifferentName 

Please check the pbix file, field parameter now working on map.
You only created for some region, you have to create for all 75 region
https://drive.google.com/file/d/14FCkzR1Ea5XlhyG0sTLYFfSYFGpdYWz6/view?usp=sharing

If solved your requirement, please mark this answer as SOLUTION.
If this comment helps you, appreciate your KUDOS 

Thanks 
Pijush

[PijushRoy]

Hi @DifferentName 

Please create a Field Parameter for 75 Region, so users can select a region to show the data in MAP
How to - https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parameters

See example

or create Unpivot other column ( you have 2308 rows in your dataset, so it should work)
https://support.microsoft.com/en-au/office/unpivot-columns-power-query-0f7bad4b-9ea1-49c1-9d95-f5882...
Select all column except the 75 Region column and Unpivot other column

After Unpivot

If solved your requirement, please mark this answer as SOLUTION.
If this comment helps you, appreciate your KUDOS 

Thanks 
Pijush