Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
WSL
Regular 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
v-piga-msft
Resident Rockstar
Resident Rockstar

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.

View solution in original post

3 REPLIES 3
v-piga-msft
Resident Rockstar
Resident Rockstar

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.

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

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.