Slicer based on date measure hides initial data

[PierreCA]

Hello, 

I'm trying to apply a slicer based on a date measure. Dates can change dynamicaly, according some rules. I have set a table that generate a serie of dates to feed the slicer .

GENERATESERIES( dateMinimum ,dateMaximum,1)

It works fine but hides intial date layout (in yellow). 

And yes, it's normal to have rows without date.

I have specify to see elements without data. 

I want to see the yellow zone before I filter the date. How can I do it?

Before enforcing the slicer...

After enforcing...

[PierreCA · Accepted solution]

Turns out the best solution was to get rid of measure and use calculated column. 

[Ritaf1983]

Hi @PierreCA 
Try to use the option "show values without data"

if this isn't help 

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

[PierreCA]

Hello @Ritaf1983 , 

The option "show values without data" is already applied when I enforce the slicer. 

In the background, a table is build GENERATESERIES  to create dates in the slicer.  

DateDemandesPlusRecentes = 

VAR dateMinimum = 
CALCULATE( MIN( 'EvolutionStatutDemande2-Test'[dateStatut]),
    'EvolutionStatutDemande2-Test'[FK_idStatutDemandeId]=16, NOT('EvolutionStatutDemande2-Test'[FK_idStatutDemandeId]=16 && 'EvolutionStatutDemande2-Test'[FK_idStatutDemandeId]=15)
)

VAR dateMaximum = CALCULATE( Max( 'EvolutionStatutDemande2-Test'[dateStatut]),
    'EvolutionStatutDemande2-Test'[FK_idStatutDemandeId]=16, NOT('EvolutionStatutDemande2-Test'[FK_idStatutDemandeId]=16 && 'EvolutionStatutDemande2-Test'[FK_idStatutDemandeId]=15)
)


RETURN

GENERATESERIES( dateMinimum ,dateMaximum,1)

and then a mesure to identifie rows with or without dates. 

m_DatePlusRecente = 


VAR MinValue = MIN(DateDemandesPlusRecentes[Value])
VAR MaxValue = MAX(DateDemandesPlusRecentes[Value])
VAR ValeurCourante = [DateDemandeOuvertePlusRecente]

RETURN
If 
(
    ValeurCourante>=MinValue && ValeurCourante<=MaxValue,
    1,
    0

)

As a result, in #1,  I can filter between rows who has the value or not in the slicer, before enforcing the slicer. 

But the moment I enforce it with a filter (in yellow) all I see are rows with a date.  I want my user to see the rows as on the previous picture, rows whithout dates included.  Then, after selecting dates, results with date only.