Using Query Parameters in Performance Analyzer query

[ldwf]

Hello, I have a query I copied from PBI desktop and am pasting it into a Report Builder query which connects to a PBI dataset in the cloud.  I created two query parameters (i.e, not report parameters) by clicking on Query Designer and adding the two parameters.  One is a date and the other is a text value.  I want to default both to a specific value but still allow the user to select any value from the dropdown list.  when I run the query, the date parameter doesn't default to any date (I need to select it in the date picker), and the text value defaults to some text that looks like this: [Dim Country].[Country_Name].&[United States].  I want the default value to just be United States, which is the value I indicated (i.e, selected) as the default value when I built the parameter.  Any ideas how I can get this default to work correctly?  Thanks!

[v-yanjiang-msft]

Hi @ldwf ,

Maybe I haven't understand your problem correctly, why not directly set the United States in the parameter.

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ldwf]

I did set this as the default parameter, but for some reason it didn't take.  In any case, I have a bigger issue in that I want to be able to modify the code such that for whatever date the user selects in the prompt, it retrieves the past 13 months from that date, so if user selects October, 2022, the code needs to be updated to return data where the date is between 'prompt date minus 13 months' and 'prompt date'; i.e, between October 2021 and October 2022