Forum Discussion
Create filter from many columns
- 2 years ago
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=sharingIf solved your requirement, please mark this answer as SOLUTION.
If this comment helps you, appreciate your KUDOS
Thanks
Pijush
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-f588221c7098
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