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.
Hi @boddydan
Please refer to the considerations and limitations of M parameter.
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.
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
User | Count |
---|---|
136 | |
59 | |
56 | |
55 | |
47 |
User | Count |
---|---|
128 | |
77 | |
55 | |
54 | |
51 |