Forum Discussion
Date filter not filtering values with the same data source
Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
If you are unsure how to do that please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
If you want to get answers faster please refer to https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
I attached a link with the pbix file I made for testing with the same error. Note that this is the import mode only, in this version the filtering works correctly, but for some reason when I have the exact same data, from the exact same source, with the exact same visuals in direct query mode then the filtering doesn't work at all as previously mentioned, the only difference being the creation of this hierarchy which I'm not using (see the pbix) and the direct query version not accepting NULL values by default.
Any suggestions? I trully don't know if there's some obvious mistake I'm overlooking.
Sorry for the delay from previous answer, I had no way to share even this version since I couldn't acces any of the drive options.
https://drive.google.com/drive/folders/1CyuievXYJ8Vs7koToOC1R2brRUVRukdQ