Date or Number Between in Slicer

[DuncanYeah]

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

[lbendlin]

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

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/1447...

[DuncanYeah]

I 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)

[DuncanYeah]

Hi,

I got what you mean, but my point is how to remove the null when I using the slicer

as the null value is out of the selected date range.

Or would it be a way that slicer show blank to maximum value if the column contain null value. 

If the slicer does not show blank but the result include blank, isnt it misleading?

Best 

Duncan 

[v-yajiewan-msft]

Hi @DuncanYeah , hello Ashish_Mathur and lbendlin, thank you for your prompt reply!

Per my test,when the slicer is added for the first time, the blank values in the table show up and disappear when I drag from the start date in the slicer.

Please update to the latest version to check the results as when I open your pbix it says it is an earlier version.

Best regards,

Joyce

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[DuncanYeah]

Hi Joyce,

Thx for your reply.
It true that the null value will disappear when drag from the start date in the slicer.
But I cannot control how the user use this date slicer.

Form the user point of view, no matter how he drag the slicer, there should not has any null value return. As the null value is not included in the date range.

Best Regards,

Duncan