cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
RMDNA
Solution Sage
Solution Sage

Date vs. date hierarchy slicer preventing proper filtering?

Hi all,

Running into someting weird here. I have some event dates (Start Date) with some attributes (Measure 1 and Count 1). When I filter on Event Date using the "between" slicer at the top, it filters the dates in the left table just fine.

success.PNG

However, when I use in a slicer that's formatted to use the hierarchy on the right, something goes wrong. It filters the middle table of just the dates properly. For the table on the left, it sets the values from the other years as 0, but it doesn't actually filter them out. 

failure.PNG

Both slicers are using the exact same field. Is it the presence of the measures? I wouldn't think they'd be able to impact filtering, since they're on the many side of a single-direction 1:many relationship.

I'm trying to figure out how to anonymize this to upload, but it would take a while. Any thoughts?

1 ACCEPTED SOLUTION
fhill
Resident Rockstar
Resident Rockstar

Without the data set, or sample data, taking a shot in the dark....

 

If you remove 'Measure 1' from the table, does it work properly with only 'Count 1' remaining?  (I'm Guessing) the Measure calcuation is still returning Zero (instead of blank or null) when taking your '2018' selection into account.  And those Zeros are still being displayed (as opposed to a Blank or Null that would auto hide?)

 

Again, just a total guess.  If that doesn't help, try to duplciate the problem with fake data you can share, so we can take a look.  Forrest



Did I answer your question, or help you along the way?
Please give Kudos or Mark as a Solution!


I’ll be speaking at #MySummitNA this year.
Check out all the sessions, including mine here: https://hubs.ly/H0SXmgH0
I hope to see you in Houston October 12-15 #MySummitNA

Proud to be a Super User helping give back to the community!
Thank You!




View solution in original post

2 REPLIES 2
fhill
Resident Rockstar
Resident Rockstar

Without the data set, or sample data, taking a shot in the dark....

 

If you remove 'Measure 1' from the table, does it work properly with only 'Count 1' remaining?  (I'm Guessing) the Measure calcuation is still returning Zero (instead of blank or null) when taking your '2018' selection into account.  And those Zeros are still being displayed (as opposed to a Blank or Null that would auto hide?)

 

Again, just a total guess.  If that doesn't help, try to duplciate the problem with fake data you can share, so we can take a look.  Forrest



Did I answer your question, or help you along the way?
Please give Kudos or Mark as a Solution!


I’ll be speaking at #MySummitNA this year.
Check out all the sessions, including mine here: https://hubs.ly/H0SXmgH0
I hope to see you in Houston October 12-15 #MySummitNA

Proud to be a Super User helping give back to the community!
Thank You!




View solution in original post

RMDNA
Solution Sage
Solution Sage

That worked. Turns out they have to explicitly be BLANK( ) rather than any other option. 

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors