'Show Items with no data' seems to override Date-Slicer

[AlexS2023]

Hi all,

Is this normal behaviour?

I've made a matrix to show user schedules (which cost-center they're booked to and when). This works fine but by default it will only show dates where at least one person is scheduled somewhere - see Pic 1 - note 4th February is missing (no-one worked that day).

So, in order to show the days where nobody is assigned (eg weekends) I select 'Show items with no data'. With this, the missing date reappears as an empty column, but so does all of January! See Pic 2.

In both instances the Date-Slicer is set to only show from Feb onwards, so the 'Show items with no data' option appears to have overwritten it 😓 what's stranger still, I do actually have data for January, but it appears to have been filtered out.

Is this normal or am I missing something? and why stop at January, why not just show me all of time, since there was no data for last year or 1975 either. Please help me understand 🙂 and any ideas on how to fix this gratefully received 😃

TIA,

Pic 1: (Note dates are in UK formatting)

Pic 2:

TIA

Alex

[amitchandak]

@AlexS2023 , This is how show item with no data works, it does kind of left join with dim

Try a measure like this instead

0 between range
Measure = var _1= SUM(Opportunity[Opportunity count]) +0
var _min = minx(ALLSELECTED('Calendar'), 'Calendar'[Date])
var _max = maxx(ALLSELECTED('Calendar'), 'Calendar'[Date])
return
if(max('Calendar'[Date]) <_min || max('Calendar'[Date]) >_max , BLANK(), _1)

[AlexS2023]

FYI the data behind this looks like:
UserName - - - - Cost Center - - - - ScheduleDate

Alex - - - - -- - - - -Head office - - - - - 01/02/2024

Alex - - - - -- - - - -Head office - - - - - 02/02/2024

Alex - - - - -- - - - -Head office - - - - - 03/02/2024

Alex - - - - -- - - - -Head office - - - - - 05/02/2024

Alex - - - - -- - - - -Head office - - - - - 06/02/2024

Ann Example- - - -Head office - - - - - 01/02/2024

Ann Example- - - -Head office - - - - - 02/02/2024

Ann Example- - - -Head office - - - - - 03/02/2024

Ann Example- - - -Head office - - - - - 05/02/2024

Ann Example- - - -Head office - - - - - 06/02/2024

The Matrix counts the records where they match and Conditional formatting colors it in if not 0.