Forum Discussion

analyticsnags's avatar
analyticsnags
Regular Visitor
5 years ago
Solved

Single Select Slicer should Pick Latest month Whenever Data updated

I have single select filter which is having monthcolumn which is sorted by Descending.    Dec 20 Nov 20 Oct 20   Now the problem is, when we are in Dec 20 , the Dec 20 is selected as single...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    analyticsnags , I doubt it can, you have to create a column like this in date table and select this month

     

    Month Type = Switch( True(),
    eomonth([Date],0) = eomonth(Today(),-1),"Last Month" ,
    eomonth([Date],0)= eomonth(Today(),0),"This Month" ,
    Format([Date],"MMM-YYYY")
    )

     

    https://www.youtube.com/watch?v=hfn05preQYA

     

    You can also use relative date slicer

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

analyticsnags , I doubt it can, you have to create a column like this in date table and select this month

 

Month Type = Switch( True(),
eomonth([Date],0) = eomonth(Today(),-1),"Last Month" ,
eomonth([Date],0)= eomonth(Today(),0),"This Month" ,
Format([Date],"MMM-YYYY")
)

 

https://www.youtube.com/watch?v=hfn05preQYA

 

You can also use relative date slicer

analyticsnags's avatar
analyticsnags
Regular Visitor
5 years ago

This is Good work around. The clients are not fully satisfied. As mixing the text with Date column. But this sounds to be acceptable solution from technical point of view.

 

Actaully i have got an another solution as demonstarted in the video. 

https://www.youtube.com/watch?v=tXdze9PxYIg

 

But Client required the slicer to be dynamic changing(selected) based on the upcoming dates.