Date filter (same data) different result on visuals

[Tim_H]

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 selected (last 12 months) outcome is different.

using hierarchy date (top filter)

using last 12 months (bottom filter)

Is it possible to connect both filters to show the same data as in using top filter (hierarchy)?

I want to use bottom filter with top result.

Temp solution is to set both filters on same requested period..

Thanks for helping

Kind regards

Tim

[Tim_H · Accepted solution]

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 · Accepted solution]

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 · Accepted solution]

And also solved

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

[amitchandak]

@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]

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.

[plainly]

How about "show items with no data" option in the visual:

https://www.youtube.com/watch?v=MqbfaO2YmMQ

You might be also interested on my blog post on DAX date calculations:

https://www.plainlyresults.com/blog/power-bi-dax-how-to-calculate-and-filter-based-on-dates/

[Tim_H]

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.