Power bi report filter

Hi Mahizee ,

Power BI relationships won’t work directly on comma-separated lists. Relationships expect clean, atomic (single) values per row. But don’t worry, here’s how you can handle both cases. This is the simple case.

1. In the model, relate:

   • A[ID] → B[ID]

   • A[ID] → C[ID]
     
     

2. Set both relationships to bidirectional filtering
   
   

Now, filtering Table A will flow through to B and C, and this will work in both Power BI Desktop and Report Builder.

Go to Power Query Editor. Select the ID column in Table A. Use “Split Column by Delimiter” → “Split into Rows”. This turns each ID into its own row , now relationships will work

If you don’t want to split Table A directly, you can create a Bridge table like this:

• One column with all unique individual IDs (e.g. "Abc-123", "Abc-145")

• Link this Bridge table to:

  • Table A (after splitting or flattening)

  • Table B

  • Table C
    
    

This allows filter propagation without creating circular relationships. If needed, you can also pass the selected ID(s) from Table A as a parameter to filter Table C. This method works great in paginated reports when slicer-based filtering isn’t enough.