cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

Dynamic pre-select filter (but modifiable). Ex: list of years with current year preselected

Hi,

what I'm trying to achieve is this (better with an example).

 

1) Display a filter or better a chicklet with a list of years.

2) The current year should be already selected (and should dynamically change the 1st of every year)

3) User should be able to change the selected year (in the same filter/chiclet.

 

So far I was only able to manage this with 2 filters:

1) Display a filter with a list of years

2) display a filter with a calculated field "Current year = yes"

 

but to change year I have to

3) De-select Current year = yes

4) select the desired year in the other filter

 

Is there a way to achieve what I want?

 

Thanks!

Lorenzo

2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
Microsoft
Microsoft

Hi @rippuz,

 

Currently, there is no option to set default value for a Slicer currently. But if you select some value on slicer and save it, that only shows while loading initially.

 

If you have any concern on this feature, you can vote the idea here and add your comments there to improve this feature for Power BI and make it coming sooner.

 

Regards,

Charlie Liao

 

View solution in original post

Highlighted

Hi Charlie Liao,

I have voted the idea in the link you suggested: it's exactly what I need. As a workaround I am saving the reports with some filters pre selected (so my problem is limited to "current month" "current year" ecc..).

 

Thanks,

Lorenzo

View solution in original post

2 REPLIES 2
Highlighted
Microsoft
Microsoft

Hi @rippuz,

 

Currently, there is no option to set default value for a Slicer currently. But if you select some value on slicer and save it, that only shows while loading initially.

 

If you have any concern on this feature, you can vote the idea here and add your comments there to improve this feature for Power BI and make it coming sooner.

 

Regards,

Charlie Liao

 

View solution in original post

Highlighted

Hi Charlie Liao,

I have voted the idea in the link you suggested: it's exactly what I need. As a workaround I am saving the reports with some filters pre selected (so my problem is limited to "current month" "current year" ecc..).

 

Thanks,

Lorenzo

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors