I have a segmentation set up in 'between' mode on a date field. I want to be able to filter out some records from the table, but the segmentation does not display null values when it is set to 'between' mode.
Hi @Dreamer_Argento ,
When using segments in ‘between’ mode on date fields, you must consider how to handle null values. By default, the ‘between’ mode takes two parameters: a start date and an end date. However, null values are not considered valid dates, which is why they do not appear in segments.
Create custom metrics or calculated columns that explicitly handle null values.
flag = IF('Table'[Date] = BLANK() , 0 , 1 )Below is my table:
The final output is shown in the following figure:
Best Regards,
Xianda Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Dreamer_Argento ,
When using segments in ‘between’ mode on date fields, you must consider how to handle null values. By default, the ‘between’ mode takes two parameters: a start date and an end date. However, null values are not considered valid dates, which is why they do not appear in segments.
Create custom metrics or calculated columns that explicitly handle null values.
flag = IF('Table'[Date] = BLANK() , 0 , 1 )Below is my table:
The final output is shown in the following figure:
Best Regards,
Xianda Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Helpful resources
Data Days 2026 coming soon!
Sign up to receive a private message when registration opens and key events begin.
New to Fabric Survey
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
Power BI DataViz World Championships - June 2026
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
