Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Computing_Kenny
New Member

How to implement a button, which sets the day to today in a comparision

‎03-07-2024 05:44 AM

Hi everyone,

I have a report in which you can compare between different years and the current day. My problem is when I compare for example between April 2022 and April 2023 that I need a button, that sets those slicers "back" to the current date of today and the same date one year before. (7th March 2024). If anyone can give me a helping hand that would be great.

Labels:
Message 1 of 2
175 Views
0
1 ACCEPTED SOLUTION
Anonymous
Not applicable

‎03-07-2024 07:30 PM

Hi @Computing_Kenny 

 

I created two pages and added a button to each page, and when you ctrl+click on this button, it switches to a different page.

 

vjialongymsft_0-1709868562916.png

 

vjialongymsft_1-1709868575134.png

 

The specific PBIX file is attached at the end.

 

 

 

 

Best Regards,

Jayleny

 

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

How to implement a button, which sets the day to today in a comparision.pbix
Message 2 of 2
130 Views
0
1 REPLY 1
Anonymous
Not applicable

‎03-07-2024 07:30 PM

Hi @Computing_Kenny 

 

I created two pages and added a button to each page, and when you ctrl+click on this button, it switches to a different page.

 

vjialongymsft_0-1709868562916.png

 

vjialongymsft_1-1709868575134.png

 

The specific PBIX file is attached at the end.

 

 

 

 

Best Regards,

Jayleny

 

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

How to implement a button, which sets the day to today in a comparision.pbix
Message 2 of 2
131 Views
0

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

View All