Default value parameter

[Anonymous]

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

[Greg_Deckler]

@Anonymous Maybe use a query parameter?

[Anonymous]

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

[v-kelly-msft]

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!