Set a default slicer selection to current year, month and week

[Anonymous]

Hi All,

I am trying to implement a solution to fix the slicers to default selection of current year, month and week. But i didn't find any appropriate solutions. Please can anyone help me with the soultion.

I have already tried creating calculated column and replace current month with "current month text" it is working as expected but business don't like the solution. Can anyone suggest any other methods.

[hashtag_pete]

Hi @Anonymous 

in the Timeline Slicer Business Apps – Microsoft AppSource you have such an option. 

The Timeline Slicer uses quite a lot of space of your canvas, but it is nevertheless very user friendly and I found that all consumers like it a lot. 

I hope this helps? if so, kudos and solution marker are appreciated

best

hashtag_pete

[amitchandak]

@Anonymous , As of now power bi do not support use of function to initialize the slicer so you have use column like

Year Type = Switch( True(),
year([Date])= year(Today()),"This Year" ,
year([Date])= year(Today())-1,"Last Year" ,
Format([Date],"YYYY")
)

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

start week = 'Date'[Date]+-1*WEEKDAY('Date'[Date],2)+1
end date= 'Date'[Date]+ 7-1*WEEKDAY('Date'[Date],2)

Week Type = Switch( True(),
[start week]<=Today() && [end date]>=Today(),"This Week" ,
[start week]<=Today()-7 && [end date]>=Today()-7,"Last Week" ,
[Week Name]
)

Default Date Today/ This Month / This Year: https://www.youtube.com/watch?v=hfn05preQYA

[Anonymous]

@amitchandak Thanks for the response. I have already created this solution but this solution is not acceped by business. Can you tell me if there any other way to achive this.

[amitchandak]

@Anonymous , You can check custom visuals. I doubt of another way

https://appsource.microsoft.com/en-us/marketplace/apps?product=power-bi-visuals