cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
WSL Frequent Visitor
Frequent Visitor

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.

Parameter.pngPicture 2.png

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: parameter

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

 

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 REPLIES 3
Community Support Team
Community Support Team

Re: parameter

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

 

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
WSL Frequent Visitor
Frequent Visitor

Re: parameter

Thanks @v-piga-msft Cherry! will vote for the idea for sure. 

Community Support Team
Community Support Team

Re: parameter

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

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 112 members 1,624 guests
Please welcome our newest community members: