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

Anonymous's avatar
Anonymous
Not applicable
1 year ago

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's avatar
    DuncanYeah
    Icon for Helper III rankHelper III
    1 year ago

    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