Forum Discussion
Default Slicer Selection and Trend chart help!!!
- 1 year ago
Hi cmkp2675
Sorry for the late response.
There isn’t a way to have a “between” slicer default itself to the latest date dynamically. Power BI doesn’t support that out-of-the-box without bookmarks. Instead, here’s a reliable pattern that meets both of your needs:
Please do follow the below steps that will resolve your issue:-
Swap your “Between” slicer for a Relative Date slicer set to “This 1 Days,” so it always defaults to today’s date
-
In Format → Edit interactions, disable the slicer’s filter on your table visual so it continues to show every date row
-
Create a measure that ignores any slicer and always sums the last 7 days, for example:
-------------------------------------------------------------------------------
LoadDurationLast7Days =
CALCULATE(
SUM('etl_pipeline_audit'[pipeline_run_duration_mins]),
DATESINPERIOD(
'Date_Table'[Date],
MAX('Date_Table'[Date]),
-6,
DAY
)
)
------------------------------------------------------------------------------- -
If needed, use Edit interactions to turn off slicer filtering on the trend chart so it consistently displays those seven days.
If the above information is helpful, please give us Kudos and mark the response as Accepted as solution.
Best Regards,
Community Support Team _ C Srikanth. -
Hi cmkp2675
We haven't heard from you since last response and just wanted to check whether the solution provided has worked for you. If yes, please Accept as Solution to help others benefit in the community.
Thank you.
If the above information is helpful, please give us Kudos and mark the response as Accepted as solution.
Best Regards,
Community Support Team _ C Srikanth.