Forum Discussion
Include empty date values in table when changing date slider
Hi All, I have a field called "NEXT_REVIEW_DATE" which is of date datatype. I am using this field as a range slicer. There are few records with empty date value for "NEXT_REVIEW_DATE" . Wh...
Hi poojithas please check community link https://community.fabric.microsoft.com/t5/Desktop/OR-include-blank-values-in-date-slicer/m-p/959529 I hope this help
some_bih - Thanks for the link but I am unable to fix the issue. Below is the code from the link provided. I have tried to replace the [Date] field from the code with the [NEXT_REVIEW_DATE] in my case .
Also, I was unable to get to how Slicer[Allowblank] is used. Could you please share a sample pbix file if possible.
measure =
var _min = minx(allselected(Date,Date[Date])
var _max = minx(allselected(Date,Date[Date])
var _maxval = if(isfiltered(Slicer[Allowblank]),max(Slicer[Allowblank]),blank())
return
if(_maxval ="Allowblank",
calculate(sum(table[Value]),filter(all(Table[Receive Date]),Table[Receive Date]>=_min && Table[Receive Date]>=_max && isblank(Table[Receive Date])))
,
calculate(sum(table[Value]),filter(all(date),Date,Date[Date]>=_min && Date[Date]>=_max))
)