How to filter a table on value selection

Sophie_ — Tue, 29 Oct 2024 08:54:31 GMT

Hello,

i want to filter a table on a value selection.

This selection is parameter and it not on tables.

Thanks,

Sophie

Re: How to filter a table on value selection

Anonymous — Wed, 30 Oct 2024 01:27:26 GMT

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.

Re: How to filter a table on value selection

Sophie_ — Wed, 30 Oct 2024 07:52:26 GMT

Hello @Anonymous

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

Thanks !

Regards,

Sophie

topic Re: How to filter a table on value selection in Developer

How to filter a table on value selection

Re: How to filter a table on value selection

Re: How to filter a table on value selection