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




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