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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
t-atgeor
Employee
Employee

Macro Button to reset graphics in report view

Hi, am wondering if it is possible to program a button (similar to a Macro function in Excel) to operate as a Reset / Unfilter / Refresh Button in a finalized Report view, so people do not get confused how to go back once having filtered on specific data inside a graph?

 

Thanks.

3 REPLIES 3
KGrice
Memorable Member
Memorable Member

Hi @t-atgeor. You won't be able to program a button to do this. There's no macro writing or equivalent in Power BI.

 

However, if you're worried about people getting lost in the data and wanting to unfilter everything or start from scratch, you could put in a standard text box with a message to refresh the page. Just be careful that they understand they aren't refreshing the data and are simply restarting the report. Something like "F5 to Restart Report"

 

If it's in PowerBI.com, I think that will refresh the page and start them from the beginning as if they had just clicked the report. Sorry I don't have a dashboard handy at the moment to test.

Hi @KGrice, thanks for the response. Is it something which might be implemented in PowerBI for the future? Might be extremely useful for those with zero knowledge on the platform, getting fast acquainted and making it easy to understand.

 

Wish you a good day.

 

Atanas

@t-atgeor  You should check out the community ideas for things that might be implemented in future releases of Power BI. That's where people submit ideas like yours, the community votes for ideas they like, and the Power BI team uses that to help gauge what features are in high demand or would be most useful.

 

I found an idea already started where somebody wants the same reset feature. It doesn't have a lot of votes yet, but you could add yours and check out other ideas while you're at it!

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.