Read our blogs, tips and tutorials
Try our exercises or test your skills
Watch our tutorial videos or shorts
Take a self-paced course
Read our recent newsletters
License our courseware
Book expert consultancy
Buy our publications
Get help in using our site
549 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owl trainers only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
Search our website
We also send out useful tips in a monthly email newsletter ...
Persistent report filters in Power BI |
---|
Consumers of your reports can alter filters, but you can change an option to prevent these changes persisting for other users. |
We publish a monthly blog on updates to Power BI, but somehow this change slipped through the net - I only became aware of it yesterday! Suppose you have a report with filters set on a visual:
The top filter has been both locked and hidden, so won't appear in Power BI Service, but the bottom filter by region will appear.
You publish this to Power BI Service, and a user decides to focus on the East Anglia region:
The change in filter will persist (the next consumer of your report will initially only see East Anglian towns).
To get round the problem described above, you can tell Power BI not to let filters persist. Start by loading up the Power BI options menu:
Choose the option shown above from the File menu in Power BI Desktop.
Scroll down to the settings for your current report:
Choose this option at the bottom of the left-hand scroll bar.
You can now choose not to let filters persist:
Tick this box to prevent filters persisting.
When you publish your report, user B will no longer inherit user A's filter settings.
This does raise another problem: some people may want to keep their choice of filters from one view of a report to the next! You can now create personal bookmarks on Power BI Service for just this eventuality (the subject of another how-did-we-miss-this-change blog).
Some other pages relevant to the above blog include:
Kingsmoor House
Railway Street
GLOSSOP
SK13 2AA
Landmark Offices
99 Bishopsgate
LONDON
EC2M 3XD
Holiday Inn
25 Aytoun Street
MANCHESTER
M1 3AE
© Wise Owl Business Solutions Ltd 2024. All Rights Reserved.