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

Question

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

Countries	Studies
Australia, Argentina, Belgium	Study1
Argentina, Belgium, Poland	Study2
Austria, Argentina	Study3

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.

Answer 1

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