M query dynamic parameter

[Anonymous]

Iam using power bi Version: 2.115.1006.0 64-bit (March 2023) , currently working on direct import of excel file . I have created the parameter and used in my m query also for filteration, my issue is that iam not able to find option to bind the parameter to a slicer column for user filtertion. It would be great if someone could help.

[Anonymous]

Thanks a lot for the answer. Ya , I think thats the reason. I may have to find  a work around which would allow the end user to filter the calculated table as per their selection.

[v-rzhou-msft · Accepted solution]

Hi @Anonymous ,

According to your statement, I know you get data from excel file by import connection mode.

As far as I know, dynamic M query parameters give model authors more control over the filter selections to incorporate into DirectQuery source queries.

So I think you need to connect to the data source which supports DirectQuery connection mode to use this feature.

For reference: Dynamic M query parameters in Power BI Desktop

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.

[Ellenwan]

Hi,

I have premium license with June 2024 desktop version. I only created a new parameter, a table with one column which included possible value in the parameter. however, I still can't find Binding to parameter for the field in the table property advanced. Does this issue be resolved?

[foodd]

@Ellenwan ,  please create a new post with your question, instead of replying to a post that is over a year old and already has an Accepted Solution.

If your requirement is solved, please make THIS ANSWER a SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.   Proud to be a Super User!