Get latest day data when report is loaded

[Cupola24]

Hi All,

Need your help on this Issue which I am facing.I am using date range filter/slicer on my report,

The issue is when I publish my report, the filter always shows the date on which I published the report, whereas what I want is that whenever the report is loaded, re-opened or refreshed it always shows me the latest day data (later if the user wants he can go back to previous dates to fetch results but by default it should show latest date data.

The report is created on data which is fetched via import mode, also the data on the report is refreshed daily on the power bi service early monring.

I tried creating a dax and using it into the filters pane for the latest data but it messes up everything and doesn't support our purppose.

Please guide and suggest what can we do, We don't want to swtich the filter to selection, dropdown etc. we want it to be range only.

[rajasaadk_98 · Accepted solution]

Solution: Use a Dynamic Relative Date Slicer alongside a Static Range Slicer

Since you want to stick to a range slicer, which retains the visual look (as shown in your image), we can set a workaround using dynamic filters or DAX measures to ensure the latest date is always selected initially.

Steps:

1. Create a Dynamic Date Measure:

   • First, create a measure that dynamically calculates the latest date in your dataset.
   • Go to Modeling and select New Measure. Use the following DAX formula:
   DAX

   Copy code

   LatestDate = MAX(YourDateTable[Date])

   This measure will return the most recent date in your data.

2. Add a Filter Based on Latest Date:

   • In your report, you’ll keep your range slicer. To ensure the default shows the latest data, do the following:
     • Add a page-level filter using this new LatestDate measure, and set it to the latest date. This will filter the page to always show the latest date by default, while allowing the user to adjust the range on the slicer afterward.

3. Optional: Using a Bookmark for Default View:

   • After setting the slicer to your desired default state (i.e., with the date range starting from the latest date), create a Bookmark:
     • Go to View > Bookmarks and create a new one.
     • Set the bookmark as the default view. When users reopen the report or refresh the page, it will reset to this bookmark, displaying the most recent date.

4. Publish to Power BI Service:

   • Once published, whenever the data is refreshed daily, the report will default to showing the latest date range without affecting the slicer appearance.

[lbendlin]

I am using date range filter/slicer on my report,

There's your issue - right there.

Use the filter pane instead, with relative date filtering.

[Cupola24]

Hi Ibendin, currently we are using the slicer only with relative date range selection. 

Kindly suggest a way in which the slicer is always set to the current date when the report is loaded, later if the user wants he can filter on last dates from the slicer.

We don't want to give user access to filter pane we have set it to not-readible. We want to handle this on the report only.

[lbendlin]

We don't want to give user access to filter pane we have set it to not-readible. We want to handle this on the report only.

I cannot assist you if you are preventing your users from using Power BI as it is intended. I hope someone else can help you further.

[Cupola24]

what you are saying still doesn't resolves the solution.

I want the report to automatically be loaded with the latest date whenever re-freshed or newly opened.

If you are suggesting to moe the date filter to the filters pane and it would serve the purpose, kindly share the steps to do it,will try and confirm.