I have two parameters. One that prompts for the first month in the Financial Year and the other for the client code.
When I look at the tables, the M Query has worked as planned. I only have the data that I need.
Now for the Problems
I assumed the report would display the data automatically in the report. But instead, I still have to go to the Page Filter and tick the Client to have the data display. The only client code available in the Filter List is client code in the parameter.
Is this by design or have I missed something? Should the filter have happed automatically?
The client parameter is a list. I had assumed the user would only be able to choose something from that list, but they can enter anything.
Is this by design?
Final question. Having created all of these parameters, I have just read that they cannot be used when the report is published. They can only be used on Desktop.
QUERY PARAMETERS â LIST QUERY OUTPUT AS âALLOWED VALUESâ FOR A PARAMETER
One of the areas of feedback about the Query Parameters feature that we introduced a couple of months ago was being able to dynamically calculate the list of âallowed valuesâ for a given parameter based on another query, instead of having to provide a static list of values in the âManage Parametersâ dialog. With this monthâs update, customers can link to another query from which the list of Allowed Values for a Query Parameter should be retrieved.
After defining which List Query to use for retrieving the list of allowed values for a parameter, users will get the list of values in the âEdit Parametersâ dialog or as part of the âImport Templateâ experience.
Note that only queries that yield a List are supported for this feature and that this âdynamic listâ is only supported in Power BI Desktop consumption scenarios. When providing Query Parameter values in PowerBI.com, users will have to manually input the desired value in a text input field, rather than being able to pick from a list of values.
Hi @kellysolutions, did the response provided by @Melissa help you solve your query? If not, how far did you get and what kind of help you need further? If yes, kindly mark the thread as solved. Thanks!