98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Power BI training and help » Filtering in Power BI desktop
Filtering in Power BI desktop
Resolved · Low Priority · Version 365
Tue 19 Dec 2023, 16:50Delegate Ben said...
Ben has attended:
Power BI Modelling, Visualisation and Publishing course
Filtering in Power BI desktop
Is there a feature in power BI that you can use which makes it easy to keep track of how each visual in the report is filtered?
(For example you may have a lot of visuals filtered in different ways to one another, and I am just wondering whether you need to keep track of what filters you have put on charts yourself).
Thanks!
Wed 20 Dec 2023, 11:25
Edited on Wed 20 Dec 2023, 11:27Trainer Jens said...
RE: Filtering in Power BI desktop
Hi Ben,
Thank you for the forum question.
Filtering report pages can be confusing. Of course if you use slicers you can see what is ticked. If you filter by a data point in a matrix or other visuals Power BI desktop will grey out the rest of the data.
I like to create dynamic text boxes by DAX to explain to my audience all kind of things. Also how the page they look at is filtered and if the filtering get changed the text will change accordingly to the changes.
The DAX to do this is not straight forward and need to be written based on your data model and your measures you display on your visuals.
An important DAX function to do this is SELECTEDVALUE.
When I run a DAX course I show my delegates some examples.
I have found a video on YOUTUBE which can give you some ideas.
https://www.youtube.com/watch?v=i51w9hmsIpU
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Power BI tip:Optimize Report PerformancePay attention to report performance by optimizing your data model and report design. Use the Performance Analyzer tool to identify bottlenecks in your report and improve loading times. Techniques such as using summarisation, avoiding unnecessary visuals, and optimizing DAX queries contribute to a faster and more responsive report. |
