Filtering on Individual Values an aggregated SQL query in Power BI

[NeverGiveUp]

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?

[amitchandak · Accepted 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

[NeverGiveUp]

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!!!

[v-xinruzhu-msft · Accepted solution]

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.}

[amitchandak · Accepted 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