Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
I have an aggregate of countries listed in SQL (US, CA, etc... etc...) How can I create a Power BI filter to include each individual countries and it pull in everything that has that country listed?
Solved! Go to Solution.
@NeverGiveUp , You can split the columns by delimiters into rows
https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/
Power Query Split Column , Split Column By Delimiter: https://youtu.be/FyO9Vmhcfag
or refer to this approach
Power BI- Text Part slicer to filter/search text - https://youtu.be/MKKWeOqFG4c
Hi @NeverGiveUp
If you want to display the corresponding information of a single country, for example: you can create a visual of Table, you can put the [Country] column in your table into a view filter, or you can create a slicer, and then you can filter the country you need, the visual will display the data you need according to your filter
View filters
For details, please refer to the following links:
Add a filter to a report in Power BI - Power BI | Microsoft Learn
Slicers
For details, please refer to the following link:
Slicers in Power BI - Power BI | Microsoft Learn
If none of the above meets your needs, can you provide some e images of sample or the results you expect?
Best Regards,
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I tried to accept both of these as a solution. As what I used was essentially both responses! Thank you both very much for your help!!!
Hi @NeverGiveUp
If you want to display the corresponding information of a single country, for example: you can create a visual of Table, you can put the [Country] column in your table into a view filter, or you can create a slicer, and then you can filter the country you need, the visual will display the data you need according to your filter
View filters
For details, please refer to the following links:
Add a filter to a report in Power BI - Power BI | Microsoft Learn
Slicers
For details, please refer to the following link:
Slicers in Power BI - Power BI | Microsoft Learn
If none of the above meets your needs, can you provide some e images of sample or the results you expect?
Best Regards,
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@NeverGiveUp , You can split the columns by delimiters into rows
https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/
Power Query Split Column , Split Column By Delimiter: https://youtu.be/FyO9Vmhcfag
or refer to this approach
Power BI- Text Part slicer to filter/search text - https://youtu.be/MKKWeOqFG4c
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
76 | |
74 | |
57 | |
38 | |
33 |
User | Count |
---|---|
71 | |
65 | |
58 | |
50 | |
47 |