cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
boddydan
Frequent Visitor

Dynamic M Parameter working in query editor but not with slicer

Hi everyone,

I've set up a (text) M parameter which changes one of my queries depending on the parameter. When I look in the query editor and play about with my parameter it works perfectly. I can change my parameter and observe the correct output.

My problem now is with attempting to connect this parameter to a slicer. I already have a slicer set up with several different locations on a table that I have been using in the past. When trying to bind the location column of my slicer table to my parameter, all of my visuals appear as errors 'The M parameter '<myparametername>' not defined in model or M parameter type is not valid.'

 

Does anybody have any advice on how to fix this? Many thanks.

2 REPLIES 2
Ailsa-msft
Community Support
Community Support

Hi @boddydan 

Please refer to the considerations and limitations of M parameter.

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters#considerat...

Ailsamsft_0-1633487960725.png

Best Regards

Community Support Team _ Ailsa Tao

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

lbendlin
Super User
Super User

There are lots of limitations mentioned in the video.  Can you confirm that your direct query data source is suitable?

 

Dynamic M query parameters in Power BI Desktop (preview) - Power BI | Microsoft Docs

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.