Slicer from result set

[superpower]

Hello!

Is it possible to create a slicer with the result set of a table visual instead of from original dataset? To elaborate, my report has a table visual which is created by pulling columns from more than one table say Table A, Table B, Table C. Now I want to create a slicer on Column C from Table C. But the slicer should contain only the values that will be shown as an output on the table visual. But my slicers are showing all the data as I am creating the slicer form original source table C. So, most of the selections I made on slicer will be showing empty result on the table visual. How do I solve this issue. 

Thanks in advance

[ichavarria]

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

[superpower]

Thank you for sharing the steps. Would you mind to share screenshots for each of the above steps you mentioned for the solution to build slicer from result set of a table visual for better understanding.