Forum Discussion

ragnezza's avatar
ragnezza
Frequent Visitor
3 years ago
Solved

Date Range based on Slicer selection

Hello - I'm looking to return a list of the previous "X" days based on a selected day from a slicer.   For example, once a day is selected in the 'Date' slicer, I want to return the date range in t...
dynamic data filtering
Dynamic data selection
Dynamic data selection based on date
Dynamic Visuals
SELECTEDVALUE
  • ragnezza's avatar
    ragnezza
    3 years ago

    Thanks DataNinja777 . This can work if I want to have the cumulative "Daily Trends" up to the selected day.
    For this purpose I find this other solution:

    Measure =
    if( MAX( 'Main_Table'[Date]) >= SELECTEDVALUE('Date'[Date],min('Date'[Date]) )-180 &&
    MAX( 'Main_Table'[Date]) <= SELECTEDVALUE('Date'[Date],max('Date'[Date]) ),
    "Yes", "No" )

     

    And then use this 'Measure' as a filter in the visualization.

ragnezza's avatar
ragnezza
Frequent Visitor
3 years ago

Thanks DataNinja777 . This can work if I want to have the cumulative "Daily Trends" up to the selected day.
For this purpose I find this other solution:

Measure =
if( MAX( 'Main_Table'[Date]) >= SELECTEDVALUE('Date'[Date],min('Date'[Date]) )-180 &&
MAX( 'Main_Table'[Date]) <= SELECTEDVALUE('Date'[Date],max('Date'[Date]) ),
"Yes", "No" )

 

And then use this 'Measure' as a filter in the visualization.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi  ragnezza ,

    It seems that you have gotten a solution. Could you please mark the helpful post as Answered? It will help the others in the community find the solution easily if they face the same problem as yours. Thank you.

    Best Regards