Forum Discussion
Include blank date data when filter by date slicer
Hi ravitejaballa ,
Here are the steps you can follow：
1. Create a calendar table.
Table 2 = CALENDAR(DATE(2021,10,31),DATE(2021,11,7))2. Create measure.
Measure = SUMX(FILTER('MySampleData', 'MySampleData'[SignalDateStamp]>=MIN('Table 2'[Date])&&'MySampleData'[SignalDateStamp]<=MAX('Table 2'[Date]) ),[SignalValue])3. Use [Date] of the calendar table as the slicer
4. Result:
When the date is displayed from November 1 to November 7:
When the date is displayed as November 5th:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi ravitejaballa ,
Here are the steps you can follow：
1. Create a calendar table.
Table 2 = CALENDAR(DATE(2021,10,31),DATE(2021,11,7))
2. Create measure.
Measure =
SUMX(FILTER('MySampleData',
'MySampleData'[SignalDateStamp]>=MIN('Table 2'[Date])&&'MySampleData'[SignalDateStamp]<=MAX('Table 2'[Date])
),[SignalValue])3. Use [Date] of the calendar table as the slicer
4. Result:
When the date is displayed from November 1 to November 7:
When the date is displayed as November 5th:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Anonymous Thank you
Add on to your steps (for future reference to others)
-> On column, make 'Show items with no data'