PowerBI - Using a Slicer to Filter Data Within a List in a Table

In my PBI dashboard, I have a table which looks like this:

I was wondering if it was possible in any way to create a slicer to sit on the same page as this table, and when a certain country is selected it return the studies involved. i.e. using slicer I select 'Belgium' and it returns only Study1 and Study2 from the table.

I want this to able be available for multi-select, so using the slicer to select more than one country value.

I am no expert in PBI so please be as specific as possible in your answer.

• In Power BI, go to Transform data in the Home tab in the ribbon. This will open Power Query Editor.
• Find your query/table of that table.
• Right-click on the Countries column header, and select Duplicate Column. In the formula bar, rename it from Countries - Copy to Country.
• Right-click on the new Country column header and select Split Column > By Delimiter.... In the window that pops up, Expand Advanced option and select Split into Rows.
• Right-click on the Country column header, select Transform > Trim.

You should have a table looking like this:

Close and apply the Power Query window. Then back in main Power BI, you can use the new Country column for your Slicer.