Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
User | Count |
---|---|
80 | |
74 | |
63 | |
61 | |
45 |
User | Count |
---|---|
108 | |
98 | |
89 | |
82 | |
61 |