Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
RashmitaR
Helper IV
Helper IV

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
v-yulgu-msft
Employee
Employee

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.

View solution in original post

1 REPLY 1
v-yulgu-msft
Employee
Employee

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.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.