The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hello,
i want to filter a table on a value selection.
This selection is parameter and it not on tables.
Thanks,
Sophie
Solved! Go to 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.
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.