I have the data model with DimDate table inside and I would like to have a slicer on my report that range will start always from the January current year to month previous to current one (but there should be possible to select current as well as all the other months in the year - even if there is no data for them). So if there currently an April it should show the data from January to March by default. I need to use the numbers of months on the slicer and I have such column created in the Date table - so for Jan is 1, Feb is 2 etc. Below is the slicer and how it should look by default now. Any help is appreciated - I cannot find any suitable solution.
There are two ways i can think off to achive what you stated.
1. in the table that contains your date colunm add a calculated colunm for If(table1[date] < NOW() ,TRUE,FALSE)
you can then use this to filter the whole report and your slicer will shrink down to only the defaulted values
2. i always use my own date table, rather than use to built in date tables i import my own and connect all relevent dates to this table. i have a colunm in this table for month which can be used and a colunm for date_Passed that does the same check above.
i can upload a copy of my date table if you need it
Create a column as below,