How to filter a table on value selection

[Sophie_]

Hello,

i want to filter a table on a value selection. 

This selection is parameter and it not on tables.

Thanks,

Sophie

[Sophie_]

Hello @v-rzhou-msft 

sorry my question was not very detailed, it was solution three that worked for me.

Thanks !

Regards,

Sophie

[v-rzhou-msft · Accepted solution]

Hi @Sophie_ ,

Do you mean that you want to filter your underlying table by parameter slicer?

As far as I know, dynamic M query parameters only support Direct Query connection mode.

For reference:

Dynamic M query parameters in Power BI Desktop - Power BI | Microsoft Learn

If you want to filter the visual, you can create a relationship between the parameter table and data table, then create the vsiual. 

If you don't want to create a relationship between them, I suggest you to create a measure to filter your visual in visual level filter. Here is a solved post with similar issue like yours, I hope it could help you.

For reference:Solved: Parameters and slicers - Microsoft Fabric Community

Best Regards,
Rico Zhou

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