Forum Discussion

DuncanYeah's avatar
DuncanYeah
Icon for Helper III rankHelper III
1 year ago

Date 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 no...
Need Help
Show and Tell
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
1 year ago

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

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Icon for Super User rankSuper User
      1 year ago

      Hi,

      You will obviously get a null (since there is a blank in column 2 of your table)

      • DuncanYeah's avatar
        DuncanYeah
        Icon for Helper III rankHelper III
        1 year ago

        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