Forum Discussion

Tim_H's avatar
Tim_H
Helper I
5 years ago
Solved

Date filter (same data) different result on visuals

Hi   I have two date slicers refering to same data     Both refer to new created table and column Date, Date  Top one is hierarchy Bottom Date   Altough same source, same period select...
Need Help
  • Tim_H's avatar
    Tim_H
    5 years ago

    Solved by adding extra month and year column in my calendar.

     

    Just looking how to change start date of this calendar

     

     

    I want to have a roling start date...  for example Today - 730 days   (2 years)

  • Tim_H's avatar
    Tim_H
    5 years ago

    And also solved

     

    StartDate = Date.AddMonths(DateTime.Date(DateTime.FixedLocalNow()), -24)

     

  • Tim_H's avatar
    Tim_H
    Helper I
    5 years ago

    In visual "show items with no data" is used. But why have two different results for same periode depending on selected date (Date or date hierarchy).

     

    is there a possibility to connect both filters so when one is set the other automatic selects same period ?

     

    As said workaround is to set both filters for same period, but want to avoid double work and use bottom filter.