Forum Discussion
Helper IIIDate or Number Between in Slicer
Hi all,
Why do null values still appear after I select a date range.
However, I can't just filter out null values from the table because it will affect the results when the slicer is not selected.
And similar situation happened when I use a slicer to select a price range.
Please help.
Best regards,
Duncan
6 Replies
- lbendlin
Super User
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Need help uploading data? 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.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
DuncanYeahI build a pbix file with some dummy data.
https://drive.google.com/file/d/1GIez4zK1Ye5-fkhvXTQ5yB4JojFz4XOk/view?usp=sharing
- Ashish_Mathur
Hi,
You will obviously get a null (since there is a blank in column 2 of your table)
