Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Date Slicer: Default values

Dear community,   I know there are several threads regarding the question of adding default values to a slicer but so far I did not find a solution to my problem.   I am having a report with seve...
Need Help
  • Fowmy's avatar
    Fowmy
    5 years ago

    Anonymous 

    I recently made a video to solve the common default date filter problems, please refer to this video: 

    https://youtu.be/KBEsPGxDxHM


     

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous ,

 

Currently, there is no such function to set a default value for the slicer. But you can achieve this goal through the following methods.

1.Create a seperate table by entering data. 

Here I use the exclamation mark to make him the first place in the slicer. The slicer is set to single selection.

 

2. Then the measure can be created like

Measure = IF(SELECTEDVALUE('Table (3)'[default value])="!previous 7 days",CALCULATE(SUM('Main table'[Value]),FILTER('Calendar',[Date]<=TODAY()&&[Date]>=TODAY()-6)),SUM('Main table'[Value]))

 

In this way, every time you open the report, the default is the data of the previous seven days. If you want to filter, select all from the single-choice slicer and filter the date range.

 

 

Best Regards,

Stephen Tao

 

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