Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Display all months but filter on date

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

MicrosoftTeams-image.png

Is it possible to create a measure to acheive this?

Thanks

 
2 REPLIES 2
Greg_Deckler
Super User
Super User

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...


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...
Anonymous
Not applicable

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors