Forum Discussion
Solved
Include blank date data when filter by date slicer
I am trying to show all data with values as zero even we don't have data on a given date. Here is sample data. I have signalValue data only for AssetID A2. But when the user selects any date. I...
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
DataZoe
Yes, the above solution shows all assets.
However, it shows the incorrect mapping.
Example.
on 5th Nov we have data only for AssetID(A2) - OrgID(O1)
But other assets (A1, A3) is not mapped under O1.
A1 should show O2
A3 should show O3