Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Values in Slicer not refreshing with Data Refresh

I'm running a simple report that uses xls files in a sharepoint folder as source data. The user then is to filter the data by selecting which file to use from a slicer. The first couple weeks I was d...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    I truly appreciate such a quick response. I did investigate the source data as you mentioned and realized a nuance on Power Query filters that I didn't know before.

    To limit the sheer volume of data that this query will call as time goes on I filtered the xls file sources to only the files that had been modified in the last 30 days. At the report level in the PBIX filters have the option to "include today." That's not so in the Power Query. I then added a layer to the filter to catch the files where [modified] 'in the last' [30 days] OR [modified] 'is' [today].

     

    This doesn't answer why the screengrab I showed included the file that was added/modified today whereas the slicer did not. But adding that OR statement to include [Today] solved the problem.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

I truly appreciate such a quick response. I did investigate the source data as you mentioned and realized a nuance on Power Query filters that I didn't know before.

To limit the sheer volume of data that this query will call as time goes on I filtered the xls file sources to only the files that had been modified in the last 30 days. At the report level in the PBIX filters have the option to "include today." That's not so in the Power Query. I then added a layer to the filter to catch the files where [modified] 'in the last' [30 days] OR [modified] 'is' [today].

 

This doesn't answer why the screengrab I showed included the file that was added/modified today whereas the slicer did not. But adding that OR statement to include [Today] solved the problem.