Forum Discussion
parameter
Hi All,
I'm new to PBI. i have a question on the possibility to display all the parameters value in the PBI dashboard.
Example show as below, I want to display the list of values in the parameter and show this as a slicer in PBI dashboard. But in the second picture below, you can see it only displays one value which is “employee group” but not both values.
Ultimately, my objective is to use the parameter as a slicer to switch the table visualization to the view that I want to display in dashboard.
Really appreciateif anyone can help in this matter.
Hi @WSL,
Currently, the value of the Query Parameters can only be used within Query Editor and in Data Source dialogs when you getting data ,so it is not possible to reference the Query Parameter on the report.
You could vote a similar idea here.
In addition, more details about Query Parameter, you could refer to the links below.
https://powerbi.microsoft.com/en-us/blog/deep-dive-into-query-parameters-and-power-bi-templates/
http://biinsight.com/power-bi-desktop-query-parameters-part-1/
http://biinsight.com/power-bi-desktop-query-parameters-part-3-list-output/
Best Regards,
Cherry
3 Replies
Hi @WSL,
Currently, the value of the Query Parameters can only be used within Query Editor and in Data Source dialogs when you getting data ,so it is not possible to reference the Query Parameter on the report.
You could vote a similar idea here.
In addition, more details about Query Parameter, you could refer to the links below.
https://powerbi.microsoft.com/en-us/blog/deep-dive-into-query-parameters-and-power-bi-templates/
http://biinsight.com/power-bi-desktop-query-parameters-part-1/
http://biinsight.com/power-bi-desktop-query-parameters-part-3-list-output/
Best Regards,
Cherry
Thanks v-piga-msft Cherry! will vote for the idea for sure.
Hi WSL，
If my answer helps you, please mark the right reply as answer. So more people will find the solution easily.
Best Regards，
Cherry
