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
mladird
Frequent Visitor

Button that changes filter selection

Hello, 

 

mladird_0-1709050758234.png

 

I would that when i click on "previous year" (it's now on a button format, but i am open to something new!) :

- the previous year on my year slicer is automatically selected

- and, that my 4 quarters on my quarter slicer is also selected 

 

It seems like bookmark isn't a solution for my case. 

 

Thank you for the support 

 

mladird_1-1709050786404.png

 

 

4 REPLIES 4
mladird
Frequent Visitor

Hey @v-nuoc-msft , thank you for your file! would your solution works if i have several "previous year".

i.e: when i will add 2024 to my file, i will get 2022 & 2023 as previous years options. 

Hi @mladird 

 

You proposed adding 2024 to the file. At this time, 2022 and 2023 are also optional, depending on the data content you want to display.

 

Slicers are a filtering method for displaying your data.

 

Slicers in Power BI - Power BI | Microsoft Learn

 

Regards,

Nono Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

In this particular case, I will have to keep all 2022, 2023 & 2024 data, thus my issue 😔

v-nuoc-msft
Community Support
Community Support

Hi @mladird

 

For the select button you asked, the slicer will automatically select.

 

One possible reason is that you selected a slicer when creating the bookmark, which saves your current visual state.

 

Therefore, when you connect to the bookmark through the button and enter the bookmark through the button, what is displayed is the page when you saved the bookmark.

 

As the documentation says: "When editing a report in Power BI Desktop and the Power BI service, you can add bookmarks to capture the current state of a report page. Bookmarks save the current filters and slicers, cross-highlight visuals, and sort orders wait."

 

Create report bookmarks in Power BI to share insights and build stories - Power BI | Microsoft Learn

 

You can try to recreate the bookmark and take care to delete the selection in the slicer. 

 

This may solve your problem. 

 

Please see the pbix attachment below, I show a relevant example. In the "Default Selected" button, I selected the slicer when creating the bookmark, and the bookmark saved the slicer's state.

 

vnuocmsft_0-1709085712448.png

 

Regards,

Nono Chen

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.

Top Solution Authors