Filtering on Individual Values an aggregated SQL query in Power BI

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