cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
RashmitaR Member
Member

how to set a default selected option in the slicers and filters

Hi ,

 

I have 5 coulmns date, value , item , month and year

datevalueitemMonthyear
25-12-2016200a1122016
18-09-2016300a292016
1/1/2017400a312017
17-1-2017200a112017


On my report I have slicers named month and year.Also have Month and year in my page level filters

If I want my slicer to by default be set at the latest month and year that has been oneter in the date column what should I do ?

 

For the above senario i would want my month slicer to be initially by default set to 01 and the year slicer to be at 2017 .

simmilarly with the filters. 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: how to set a default selected option in the slicers and filters

Hi @RashmitaR,

 

As I know, currently the requirement that specifing a default value for slicer or filters is not a supported feature. Here is the link for the idea has been submitted to Power BI team Default Selected Slicer or Tile-By Value Configuration, you can vote it up. Our product team will evaluate it and consider to add it in future release.

 

Thanks,
Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 REPLY 1
Community Support Team
Community Support Team

Re: how to set a default selected option in the slicers and filters

Hi @RashmitaR,

 

As I know, currently the requirement that specifing a default value for slicer or filters is not a supported feature. Here is the link for the idea has been submitted to Power BI team Default Selected Slicer or Tile-By Value Configuration, you can vote it up. Our product team will evaluate it and consider to add it in future release.

 

Thanks,
Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.