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

How do I create a button to perform "Reset to default"

Hi all,

 

I have a date range slicer however, I would like to enable my user to click a button and the date range slicer will reset it to a default date range.  Is this achievable in PBI?

 

thanks

2 ACCEPTED SOLUTIONS

Accepted Solutions
PaulDBrown Senior Member
Senior Member

Re: How do I create a button to perform "Reset to default"

@Tuffy 

the procedure is correct and should work. Can you try the following? Set the slicers to your default values and then go to the bookmark and select “update”. See if it solves it.

View solution in original post

msksenthil Regular Visitor
Regular Visitor

Re: How do I create a button to perform "Reset to default"

@Tuffy 

 

Please try the same what @PaulDBrown shared above.

 

Along with that, can you confirm that clicking the button with 'CTRL' ?

View solution in original post

8 REPLIES 8
Highlighted
msksenthil Regular Visitor
Regular Visitor

Re: How do I create a button to perform "Reset to default"

Hello,

 

However you can make it with 'Clear Selections' which is at the right top of the Slicer. Or if you particularly wants in the button, you can make it with Blank button & Bookmark features in PBIClear Selections.png

 

 

PaulDBrown Senior Member
Senior Member

Re: How do I create a button to perform "Reset to default"

@Tuffy 

 

Alternatively you can create a button from the button options in the main ribbon, create a bookmark with the default values and link the button to that bookmark. I do this all the time.

Tuffy Member
Member

Re: How do I create a button to perform "Reset to default"

Hi all,

I tried the following way and my "reset to default" button did not reset back to the bookmark value in my visualisation. The following are my steps....

 

Step 1:

I set my slicer for the year range to 01/08/2017 to 31/08/2019 in the slicer.

Capture1.JPGfilter my desired bookmark range

Step 2:

I created a bookmark object 

Capture2.JPGcreated a bookmark objectCapture3.JPGthe default object is named 3 yrs

Step 3:

I click on the "reset to default" button to assigned the bookmark object to this button.

Capture4.JPGCapture5.JPG

 

Step 4:

I test it .. see following two steps testing

test 1.JPGI enlarged the date rangetesting 2 clicking on the reset button.JPGnext, i clicks the Reset button, but the date range did not go back to the bookmark range?

The bookmarked date range is 01/08/2017 to 31/08/2019. 

Despite I clicked the button, the slicer doesn't change to the bookmarked range and the total figure remain $12.4M and not $10.7M

 

Have I missed out anything in my steps?

 

Thanks,

Tuff

 

 

 

PaulDBrown Senior Member
Senior Member

Re: How do I create a button to perform "Reset to default"

@Tuffy 

the procedure is correct and should work. Can you try the following? Set the slicers to your default values and then go to the bookmark and select “update”. See if it solves it.

View solution in original post

msksenthil Regular Visitor
Regular Visitor

Re: How do I create a button to perform "Reset to default"

@Tuffy 

 

Please try the same what @PaulDBrown shared above.

 

Along with that, can you confirm that clicking the button with 'CTRL' ?

View solution in original post

Tuffy Member
Member

Re: How do I create a button to perform "Reset to default"

Hi,

 

You are right that the "Reset" button needs to be clicked together with "Ctrl" key.

Is there is a way of not using Ctrl key? I see somewhere in other reports able to do that?

PaulDBrown Senior Member
Senior Member

Re: How do I create a button to perform "Reset to default"

@Tuffy 

You only need to do the “ctrl” + click while in the Desktop app. Once you publish it to the PBI service, it will work directly by just clicking the  button (no need for the “ctrl”)

Gcobanim Regular Visitor
Regular Visitor

Re: How do I create a button to perform "Reset to default"

I am also trying similar logic as well no luck of getting it right.

Helpful resources

Announcements
Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 247 members 2,723 guests
Please welcome our newest community members: