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
Microsoft Employee
Microsoft 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.

t-atgeor
Microsoft Employee
Microsoft Employee

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.

July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

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