Forum Discussion

bdherh's avatar
bdherh
Helper I
1 year ago
Solved

How to filter on blank AND date range

I have a report that shows the top 6 rows with blank dates as the heading.  Then the data starts with dates.  The user wants a date slider, but when I do that, the top 6 disappear because they dont have a date.  Is there any way to include the blank dates AND the slider dates in the filter?

 

 

 

 

 

 

Need Help
  • v-pnaroju-msft's avatar
    v-pnaroju-msft
    1 year ago

    Hi bdherh,

    Please review the new PBIX file (UpdatedSlicer_date) attached to my last response and check if it resolves your issue. I am attaching it again for your quick reference.

    If you find our response helpful, kindly mark it as the accepted solution and provide kudos. This will help other community members with similar queries.

    Should you have any further questions, please feel free to contact the Microsoft Fabric Community.

    Thank you.




9 Replies

  • v-pnaroju-msft's avatar
    v-pnaroju-msft
    Community Support
    1 year ago

    Hi bdherh,

    Please find attached the screenshots and the revised PBIX file, which may help in resolving the issue:

    Input Data:

    Output:

    If you find our response helpful, kindly mark it as the accepted solution and provide kudos. This will help other community members with similar queries.

    Should you have any further questions, please feel free to contact the Microsoft Fabric Community.

    Thank you.

  • Jai-Rathinavel's avatar
    Jai-Rathinavel
    Super User
    1 year ago

    Hi bdherh  The Date Slider Slicer does not display blank dates by default. As a workaround, you can create a bookmark specifically for blank dates and use the Visual filter in the right-side pane to refine your display accordingly. You can place your bookmark button like below

     

    Thanks,

    Jai

     

  • v-pnaroju-msft's avatar
    v-pnaroju-msft
    Community Support
    1 year ago

    Thankyou, Ashish_Excel, Jai-Rathinavel for your response.

    Hi bdherh,

    We appreciate your inquiry submitted through the Microsoft Fabric Community Forum.

    Please find attached the screenshot and PBIX file, which may assist in resolving the issue:

    If you find our response helpful, kindly mark it as the accepted solution and provide kudos. This will help other community members with similar queries.

    Should you have any further questions, please feel free to contact the Microsoft Fabric Community.

    Thank you.

    • bdherh's avatar
      bdherh
      Helper I
      1 year ago

      Hi,

      This is doing what mine currently is.  If you change the date, the rows with the blank date stay.  What I need is for those to always show.  

       

      For example, in this case I would still need to see rows 1-7, with row 7 and 8 only being removed

       

      • v-pnaroju-msft's avatar
        v-pnaroju-msft
        Community Support
        1 year ago

        Hi bdherh,

        Please review the new PBIX file (UpdatedSlicer_date) attached to my last response and check if it resolves your issue. I am attaching it again for your quick reference.

        If you find our response helpful, kindly mark it as the accepted solution and provide kudos. This will help other community members with similar queries.

        Should you have any further questions, please feel free to contact the Microsoft Fabric Community.

        Thank you.




  • bdherh's avatar
    bdherh
    Helper I
    1 year ago

    Hello Jai

    I guess I'm not understanding your solution.  Just to be clear, I ALWAYS want to show the rows with blank dates, and then only show those rows "with" dates based on the slider.  Is that what you understood?

    Thank you