Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Tim_H
Helper I
Helper I

Date filter (same data) different result on visuals

Hi

 

I have two date slicers refering to same data

 

Capture.JPG

 

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)

Tim_H_0-1614156879186.png

using last 12 months (bottom filter)

Tim_H_1-1614156967281.png

 

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

 

 

2 ACCEPTED SOLUTIONS
Tim_H
Helper I
Helper I

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

 

Just looking how to change start date of this calendar

 

Tim_H_0-1614248758407.png

 

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

View solution in original post

And also solved

 

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

 

View solution in original post

6 REPLIES 6
Tim_H
Helper I
Helper I

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

 

Just looking how to change start date of this calendar

 

Tim_H_0-1614248758407.png

 

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

And also solved

 

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

 

amitchandak
Super User
Super User

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

No measures are used for both filters.

 

both refer to same data

 

only difference

 

Tim_H_0-1614158167580.png

 

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
Regular Visitor

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/

 

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.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.