Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Sophie_
Frequent Visitor

How to filter a table on value selection

Hello,

i want to filter a table on a value selection. 

This selection is parameter and it not on tables.

 

Thanks,

Sophie

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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.

View solution in original post

2 REPLIES 2
Sophie_
Frequent Visitor

Hello @Anonymous 
sorry my question was not very detailed, it was solution three that worked for me.
Thanks !
Regards,
Sophie
Anonymous
Not applicable

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.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.