Forum Discussion
Remove the months with no data?
Hey everyone,
I would like to remove the months with no data from this slicer. I have tried many filters (e.g. sessopms >0, not blank, last 30 years) but nothing works:
The months above are for 2020, however you can choose any year you want for the view.
My requirement is to have only past and current months show. I.e. until July at the time of writing this post. Is there any way to do this? I am using a calendar table which creates dates for the last 4 years until today.
Anonymous , Drag a measure from your fact and use <> blank filter.
Something very similar done here
https://www.youtube.com/watch?v=cyOquvfhzNM
3 Replies
- Greg_Deckler
Community Champion
Anonymous - Perhaps create a column in your table that is something like IF([Date] <= TODAY && [Date] >= DATE(YEAR(TODAY()),1,1). Then you could just filter on this column.
- amitchandak
Super User
Anonymous , Drag a measure from your fact and use <> blank filter.
Something very similar done here
https://www.youtube.com/watch?v=cyOquvfhzNM
Thanks amitchandak,
the video really helped!
