This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. We're covering it all. You won't want to miss it.
Learn moreLevel up your Power BI skills this month - build one visual each week and tell better stories with data! Get started
Hi,
I have a table in my report and when a row is selected it highlights as black and the rest of the table goes to a grey colour.
I’m just wondering if there’s a way (Ideally a button option) that would reset the table to its state showing the entire table. This would need to keep the slicer option that’s selected and not show all.
I’m aware of buttons and bookmarks to clear filters etc. but I didn’t know if there was an option to do this or an alternative way around it?
Thanks in advance
Liam
Solved! Go to Solution.
@Anonymous ,
This feature are now available in power bi service, you can click Option-> Report settings-> Enable "Persistent filters" to make it available.
However, this feature is still not available in power bi desktop, so I'm afraid you still need to use "Button&Bookmark" solution as a workaround before the feature released. You can also vote for this idea and comment there.
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous ,
This feature are now available in power bi service, you can click Option-> Report settings-> Enable "Persistent filters" to make it available.
However, this feature is still not available in power bi desktop, so I'm afraid you still need to use "Button&Bookmark" solution as a workaround before the feature released. You can also vote for this idea and comment there.
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Check out the April 2026 Power BI update to learn about new features.
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
| User | Count |
|---|---|
| 38 | |
| 28 | |
| 27 | |
| 22 | |
| 18 |
| User | Count |
|---|---|
| 67 | |
| 37 | |
| 32 | |
| 25 | |
| 25 |