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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

Slicer Parameter

Hi all,

In scope of my project i have created in the Power BI Query a parameter ,which gives the user the option to choose one of the available values. 

The problem is, when the user decides to change the value of this parameter he must choose the option "Transform Data"  and then "Edit Parameters".

I would like to ask if it is possoble to create a slicer which contains all the possible values of this parameter and when the user chooses one of them, then dynamically change all the dashboards. 

1 ACCEPTED SOLUTION
v-eachen-msft
Community Support
Community Support

Hi @Anonymous ,

 

I am afraid that Power BI doesn't support it currently. You could vote for the following ideas to improve Power BI and make this feature coming sooner.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/17221487-create-a-parameter-slicer-that-refreshes-queries-o

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/17003566-default-slicer-values-via-query-parameter

 

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

View solution in original post

3 REPLIES 3
PSEJR
Frequent Visitor

There are some "workarounds" you could do, but it depends on what your parameters actually changes?

Does it change the data source? A field value for filtering the source? Is it a value used in a calculation? Is it a loop limit? etc.

 

v-eachen-msft
Community Support
Community Support

Hi @Anonymous ,

 

I am afraid that Power BI doesn't support it currently. You could vote for the following ideas to improve Power BI and make this feature coming sooner.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/17221487-create-a-parameter-slicer-that-refreshes-queries-o

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/17003566-default-slicer-values-via-query-parameter

 

Community Support Team _ Eads
If this post helps, then please consider Accept it as the solution to help the other members find it.
Greg_Deckler
Super User
Super User

Not right now.

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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