cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
NiugeS
Helper V
Helper V

Date Slicer with Blanks Included

Hi all,

 

I'm fairly new to Power BI and hoping someone can offer some suggestions on the below.  I've looked up calendar tables etc but not sure if that will be any benefit.  In short, i'm looking to have two slicers with the below table.  For example, I want Key's resolved before 19/04/2020 but created before 30/04/2020 however, if not resolved, to include.

 

KeyCreatedResolved
115/03/202018/04/2020
218/03/2020 
325/03/202020/04/2020
428/03/202025/04/2020
531/03/202030/04/2020

 

With the slicers working, I would be able to get the following:

218/03/2020 
325/03/202020/04/2020
428/03/2020

25/04/2020

 
Any ideas greatly appreciated.


Thank you

1 ACCEPTED SOLUTION

@NiugeS see attached.

 

I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





View solution in original post

5 REPLIES 5
parry2k
Super User III
Super User III

@NiugeS you surely need calendar table one for created before selection and one for resolve after selection, one you have these table and slicers, it is super easy from there.

 

I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





@parry2k  THank you for the feedback.  So I need to create two calendar tables?  One for created and one for resolved?  I've not made a calendar table so will look that up i'm sure there are lots of posts on that here.

@parry2k 


I've created the two calendar tables however i'm still having a bit of difficulty.  If I set the resolved slicer for 19/04/2020, the row with the blank date is removed.  I have attached an example PBIX file in case i'm doing something wrong Date Pbix Example 

 

Thank you

@NiugeS see attached.

 

I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





View solution in original post

@parry2k Thank you.  It took me a bit of time to undertand the measure and try and put it into another pbix.  Thanks for the help, greatly appreciated.

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

Top Solution Authors
Top Kudoed Authors