cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
nbarsley
Frequent Visitor

Slicer on Filtered Dataset not updating online

Hi, 

I have a date slicer which is sourced from a direct update table. The table is filtered in the advanced editor:

Table.SelectRows(dbo_CALENDAR, each [DAY_ID] >= Date.From(Date.AddDays(DateTime.LocalNow(),-45)) and [DAY_ID] <= Date.From(DateTime.LocalNow()) )

 

If I refresh the data and publish the report the slicer is updated on the web. But the slicer will not update when the report is refreshed from the web. It will keep the last date range from when the report was published. Am I missing something? 

1 ACCEPTED SOLUTION

It seems as if using a filter advanced editor is only dynamic when the report is republished. I've converted the slicer to a filtered sql view. Using a view as the datasource has fixed the issue. 

View solution in original post

5 REPLIES 5
v-lili6-msft
Community Support
Community Support

hi @nbarsley 

when you log out of Power BI and come back to a report, the same items will be selected as when you left.

For your case, you could add a flag column in date table and then use it as a slicer.

For example:

If([Date]=TODAY(), "Today",  "Not Today")

Then set filter is "Today"

 

Regards,

Lin

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

It seems as if using a filter advanced editor is only dynamic when the report is republished. I've converted the slicer to a filtered sql view. Using a view as the datasource has fixed the issue. 

JarroVGIT
Resident Rockstar
Resident Rockstar

If you say refreshed from the web, are you talking about 'revisiting the report page'  or are you talking about a hard refresh of the dataset? Hitting refresh on the report view online doesn't refresh the underlying dataset, but refreshes the datamodel from the dataset. 

You can schedule a refresh on the dataset which should result in the correct data being loaded when looking at your report online. I would refer you to this documentation to configure a scheduled refresh of the dataset after you have published your report to the Power BI Service: https://docs.microsoft.com/en-us/power-bi/refresh-scheduled-refresh

 

Kind regards

Djerro123

-------------------------------

If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.

Keep those thumbs up coming! 🙂





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Im confused! Every other query in our report refreshes when we hit the refresh button on the web. We're using directquery. Its only the slicer that isnt updating. 

I am sorry I didn't understood correctly what you meant. 

 

Could you share what you are seeing online vs what you expected to see? I know there is some caching going on with the online service that allows visuals to reload instantaneously and that might be applicable here. 

 

Kind regards

Djerro123

-------------------------------

If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.

Keep those thumbs up coming! 🙂





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
September Update

Check it Out!

Click here to learn more about the September 2022 updates!

Power BI Show episode 9

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power BI Dev Camp Session 25

Ted's Dev Camp - August 25, 2022

Watch Session 25 of Ted's Dev Camp.

Top Solution Authors