Display all months but filter on date

[Anonymous]

Hi

I would like to know if it is possible to display all months for a graph but select a date in a slicer.

Like I want the full month value for January and February and month to date for March

Is it possible to create a measure to acheive this?

Thanks

[Greg_Deckler]

Yes, you would need an ALL statement in there and then filter down to what you need. See if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.

https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TIT...

[Anonymous]

Thanks

But it seems like this measure does not behave like I want

Measure = 
VAR _MAXYEAR = MAX( 'Date'[Year] )
VAR _TMPTABLE = CALCULATETABLE( 'Date'; ALL( 'Date'[Year] ); ALL( 'Date'[Month] ); ALL( 'Date'[Date] ) )
RETURN
SUMX(FILTER(_TMPTABLE; 'Date'[Year] <= _MAXYEAR);[Turnover Tax Excl EUR])

I tried to have all possible dates I could, but as a result, in my graph the only date displayed is 2020-03-16