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
v-yetao1-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
Exciting changes

Power BI Community Changes

Check out the changes to the Power BI Community announced at Build.

May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Kudo Data Story carousel

Data Stories Gallery

Visit our Data Stories Gallery and give kudos to your favorite Data Stories.

Top Solution Authors