Forum Discussion
What is a list query for a parameter?
Hi Tracy,
Query list is a list of values created in the blank query using M Language. It is basically the ordered list of values and defined using comma separated values with any data type enclosed in braces.
For example, Type the list of values of any data type in the advanced editor window.
Remove all the code in Advanced Editor and just type below list of values
{"Ryan","Matthew","Todd"} and Press Done.
You can use this list of values in your parameter and this can be done by creating a new parameter and in the Suggested Values field, Select Query and Query field will become active now. You can select the current value as per your preference.
This list of values will be shown in your parameter values.
Hope this has clarified ypour understanding.
For more information on this, Please visit this blog.
Thanks & Regards,
Bhavesh
Hi Tracy,
Query list is a list of values created in the blank query using M Language. It is basically the ordered list of values and defined using comma separated values with any data type enclosed in braces.
For example, Type the list of values of any data type in the advanced editor window.
Remove all the code in Advanced Editor and just type below list of values
{"Ryan","Matthew","Todd"} and Press Done.
You can use this list of values in your parameter and this can be done by creating a new parameter and in the Suggested Values field, Select Query and Query field will become active now. You can select the current value as per your preference.
This list of values will be shown in your parameter values.
Hope this has clarified ypour understanding.
For more information on this, Please visit this blog.
Thanks & Regards,
Bhavesh
Yes!
And it is important to point out that this list can be dynamic and not just a manually typed in list--it can be based on any other query. See the blog link Bhavesh posted above for more details about that.
- hi bhavesh,
thank you - thank you - thank you!
i was able to create the list query and use it.
tracyThank you for your appreciation.
Thanks & Regards,
Bhavesh
Is it possible to change parameters for posted report to Power BI?
Not yet.
"Note that currently, parameter values can only be modified within Power BI Desktop. We’re actively working on ways to allow users to change parameter values within PowerBI.com for published reports consumed via the Web experience."
Read this post: https://powerbi.microsoft.com/en-us/blog/deep-dive-into-query-parameters-and-power-bi-templates/
