Forum Discussion

NiugeS's avatar
NiugeS
Helper V
6 years ago

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...
Need Help
NiugeS's avatar
NiugeS
Helper V
6 years ago

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

parry2k's avatar
parry2k
Super User
6 years ago

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!

  • NiugeS's avatar
    NiugeS
    Helper V
    6 years ago

    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.