Forum Discussion
How to filter on blank AND date range
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.
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
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.
Hi
Yes this is doing exacly what I need. I see you have a new Date table with generated dates and the slicer is based on that date. The table is based on your DataTable. I'm not seeing the correlation between the slicer Date table and the table Data Table.
Nevermind. I overlooked the New Measure you created. This works as I needed
Thank you for your help