Forum Discussion

catmint's avatar
catmint
Frequent Visitor
3 years ago

Dynamic period in Timeline slicer

Hi community!

 

How can I dynamically limit the range on the date slider using the conditions like: SELECTEDVALUE

 

In my case, I want to set the condition when selecting a certain version of the budget (actuals) in another slicer, the date range on the date selection slider was limited to the maximum available date, in other cases - the entire period.

 

I have a measure of the maximum available date, but I can't figure out if it's even possible to dynamically limit this range. In the particular case model is simple:

1. Fact table 
2. Calendar
3. Some additional tables for SELECTEDVALUE filters

 

This is what the slider looks like all the time: 

Desired result when selecting the AC version:

 

As a date I'm using date from Calendar table. 
Max date calculation:
CALCULATE(MAX(Fact Table[Date]), FILTER(Fact Table, Fact Table[Value] <> 0), Fact Table[Version] = "AC") -- the fact table has zero-values for future periods, if that matters.

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi catmint ,

    Please create relationship between the 2 tables.

    How to Get Your Question Answered Quickly 

     

    If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

     

    Best Regards
    Community Support Team _ Rongtie

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

    • catmint's avatar
      catmint
      Frequent Visitor
      3 years ago

      Hi Anonymous ! 

      Thank you for your quick response and trying to help. 

      I made an example .pbix and attach it.

      In my example, table1 contains only three columns.

      Budget version - contains several versions of the budget, but actuals are not complete. That's why I want to limit the date selection range when selecting this version. So that when comparing one version to another, the capture will be by the last available actuals date.

      I tried to make an additional table to filter with a limited date range, but it does not allow me to compare 2 versions because it limits the context (VersionsDates)

      As an example I made 2 sheets in the report, on the first "Works" dynamic version selection works, but without dynamic range selection. On the second sheet "Not Works" the range selection works when selecting Actuals, but no ability to select a version to compare.


      Link: https://1drv.ms/u/s!ApO9IZha2FT_gSq7ToCXXVX7GuWo?e=9y9SC6