Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Month (numeric) slicer default settings

Hi guys,   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...
Need Help
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi,

 

Create a column as below,

Month Slicer = Orders[Month]<MONTH(TODAY()) which give syou boolean value T/F.
and use this Month slicer as page/visual filter as per your usecase & set it to True.
below is the result,
 
let me know if this works for you!
 
Regards
Harsha Vardhan
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Thanks, but that is not solving my issue as I need to have a slicer that will display all months on it and to display the data to current month as well.

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    7 years ago

    Anonymous in my original reply I mentioned it is not possible at this point. Check ideas forum and vote if this idea exists otherwise create new idea