Slicer from result set

Yes, it is possible to create a slicer based on the result set of a table visual in Power BI. Here's how you can do it:

1. Create a table visual that contains the columns from Table A, Table B, and Table C that you need for your report.

2. Go to the "Visualizations" pane, and select the "Table" visual that you just created.

3. In the "Visualizations" pane, select the "Format" tab.

4. Under the "Table" section, turn on the "Include in Report Refresh" option.

5. Now, create a slicer based on the column that you want to filter from Table C.

6. With the slicer selected, go to the "Visualizations" pane, and select the "Format" tab.

7. Under the "Data" section, turn on the "Only Relevant Values" option.

This will ensure that the slicer only displays values that are relevant to the current filter context, which is based on the table visual. When you select a value in the slicer, the table visual will be filtered accordingly.

Note that this approach may not work if you have a very large dataset or if your table visual has many rows. In that case, you may want to consider using a direct query or live connection to your data source, or optimizing your data model to improve performance.

Best regards, 

Isaac Chavarria 


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly