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)

     

amitchandak's avatar
amitchandak
Super User
5 years ago

Tim_H , Can you provide details about the first filter. How it works, Does it use any measure.

 

Is the same visual show with both filters?

 

Can you share  a sample pbix after removing sensitive data.

Tim_H's avatar
Tim_H
Helper I
5 years ago

No measures are used for both filters.

 

both refer to same data

 

only difference

 

 

only difference top is Date Hierarchy, bottom Date selected. (and ofcourse how it's presented)

 

Edit : in my visual also date hierarchy is used. When setting this to date it's shows correct timeframe.