Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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.
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 44 | |
| 40 | |
| 33 | |
| 31 | |
| 23 |
| User | Count |
|---|---|
| 127 | |
| 116 | |
| 90 | |
| 73 | |
| 69 |