Query parameter not showing in Filter Rows window

[awtahhan]

Hi,

I created 2 query parameters RangeStart and RangeEnd but they are not showing in the Filter Rows window? any ideas why.

Screenshot for my Filter Rows window

https://ibb.co/Rz3kXML

Thanks in advance.

[amitchandak]

@awtahhan , not very clear with screenshot

See if these can help

https://www.biinsight.com/power-bi-desktop-query-parameters-part-1/

https://docs.microsoft.com/en-us/power-bi/service-url-filters

[AllisonKennedy · Accepted solution]

First check that you have set the data type for your parameters to Date.

If you still can't see them in the filter, then you can just pick a random date and manually edit the M code in the formula bar to replace the dates with RangeStart and RangeEnd.

Turn the formula bar on in the View tab in Power Query.

[awtahhan]

Thanks for the quick reply,

yes the issue was in the data type, the data type of the column is date/time/zone type, while the query parameter type is date/time this is why it was not showing correctly.