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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
brs09j
Helper II
Helper II

Is it possible to create a paramter and have it applied without a prompt?

I have unchecked the required box when creating a parameter but don't see a difference between when the box is checked. I don't see the ability to not select or type in an input. I'm thinking I am missing something here. I'm also guessing that no matter what the prompt for the parameter will show though.

 

Thanks.

1 ACCEPTED SOLUTION
Greg_Deckler
Community Champion
Community Champion

When you manage the parameter, do you have a current value set?



Follow on LinkedIn
@ 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!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

5 REPLIES 5
Greg_Deckler
Community Champion
Community Champion

When you manage the parameter, do you have a current value set?



Follow on LinkedIn
@ 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!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

@Greg_Deckler

 

Thank you. I now see that when the required box is checked you need to set a current value but when it is not checked no current value is needed.

 

No matter what, a prompt will always display though right?

 

Also, if I leave the current parameter value box blank I notice that the data on my table becomes empty. For instance, my query parameter returns 3 years (2016, 2017, 2018). The fact table has a year column that is filtered based off this query parameter. Leaving it blank causes the table to be empty. Thus, if you don't have an input required isn't that going to break your model?

Hmmm, this is not my experience with parameters when working with Folder ingests for example. If the parameter current value is set, then it doesn't prompt me for the folder name, for example. 



Follow on LinkedIn
@ 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!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

@Greg_Deckler

 

When I open the Power BI file I'm never prompted for a parameter but if I save as a template and open I'm always prompted for a parameter.

Ah, I must have missed the template portion of your question. Yeah, that would definitely be the case.



Follow on LinkedIn
@ 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!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Top Solution Authors