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
Anonymous
Not applicable

Default value parameter

Hello everyone, I am creating a text parameter but not a list and I would like to put a default value when the report is opened. I saw that with the parameter list I can set the default value while with the single parameter no. Is it possible through the M language to enter a default value? Thank you

3 REPLIES 3
Greg_Deckler
Super User
Super User

@Anonymous Maybe use a query parameter?


@ 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!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...
Anonymous
Not applicable

I can't use the query parameter because I use direct query

Hi @Anonymous ,

 

In direct query,you can also use query parameter,check the blog below:

https://blog.gbrueckl.at/2019/03/using-power-bi-desktop-direct-query-with-parameters/#:~:text=So%20the%20%E2%80%9Cfeature%E2%80%9D%20is%2C,parameterize%20your%20Direct%20Query%20queries.

 

Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!

 

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.