Why Do My Visual Filters Update with Date Changes, but Page Filters Don’t? (DirectQuery + Parameter

[bdpr_95]

Hi everyone,

I’m working on a Power BI report using DirectQuery connected to a Snowflake function, and I’ve encountered a behavior I’d like to understand better.

To make the report dynamic, I created a parameter in Power Query to filter data by date. This parameter is then used in my SQL statement, so every time I change the parameter value, Power BI sends a new query to Snowflake with the updated date.

To make this user-friendly, I built a Date dimension table and bound the parameter to the date field. This allows me to use a date slicer in the report, and every time I change the date through the slicer, Power BI updates the visuals by querying Snowflake with the selected date.

So far, so good.

However, I noticed something odd:

• When I change the date using the slicer, the filters applied at the visual level update correctly, they reflect only the values relevant to the selected date.
• But when I use the same fields in the page-level filters (Filter Pane on the right), the values do not update. They remain static, based on the original parameter value from Power Query.

My question is:

Is there a way to make the page-level filters behave like the visual-level filters, that is, to reflect the updated data based on the selected date in the slicer?

Or, more specifically:
Is it possible to sync the Power BI slicer (which updates the parameter) with the page-level filters, so they both reflect the same filtered dataset?

Thanks in advance for any insights or workarounds!
Really appreciate the help.

[v-hjannapu · Accepted solution]

Hi @bdpr_95,

I would also take a moment to thank @DataVitalizer , for actively participating in the community forum and for the solutions you have been sharing in the community forum. Your contributions make a real difference.

 I understand your setup where you are using a parameter in Power Query to filter Snowflake data based on date, and you are changing it through a slicer.

The reason why page-level filters are not updating is because Power Query parameters don't work like regular filters. Once the data is loaded, those parameters don’t change based on what you select later in the Filter Pane. But slicers on the report canvas can send new queries when you change the date  that’s why visuals update correctly.

What you can do:
     Use slicers on the page instead of page-level filters.
     If you want the same slicer on multiple pages, go to the View tab and use Sync Slicers.

Hope the above provided information help you resolve the issue, if you have any further concerns or queries, please feel free to reach out to us.

Best Regards,
Harshitha.

[v-hjannapu]

Hi @bdpr_95,

I hope the information provided above assists you in resolving the issue. If you have any additional questions or concerns, please do not hesitate to contact us. We are here to support you and will be happy to help with any further assistance you may need.

Regards,
Harshitha.

[DataVitalizer]

Hi @v-hjannapu 
Thank you for the kind recognition.

I'm grateful to contribute and pleased my efforts are meaningful.

Did it work? 👍 A kudos would be appreciated
🟨 Mark it as a solution to help spread knowledge 💡

🟩 Follow me on LinkedIn

[DataVitalizer]

Hi @bdpr_95 

Instead of using the Filter Pane, use the slicers on the report page. Place a slicer (for example, date) directly on the canvas after removing any page-level filters.

Use the View menu's Sync Slicers feature if you require the same filter on several pages.

Did it work ? 👍 A kudos would be appreciated ‌‌📢 Mark it as a solution to help spreading knowledge