Forum Discussion
Helper IFilter Visualization to filter out all blanks
Hi Chaps,
So I have created a report with multiple charts based on multiple fields. All of these fields contain blanks and I want to be able to add a filter to the top of the report that will purely have "Include Blanks" & "Exclude Blanks" and when selecting Exclude then all filtered charts will remove blanks.
Cheers,
D
I sugget you create bookmarks. So you can create 2 new buttons and assign a bookmark to each one of them
With a bookmark you create a snapshot of the report based on certain rules that you apply to visuals or filters.
1st Bookmark will have filters where all Non-Blank values will be selected
2nd Bookmark will have Blank values selected in filters
2 Replies
- parry2k
Super User
DarylRob this is going to be tricky, you need to create a measure and then apply a visual level filter and in this measure check if exclude or include is selected. Maybe share a sample pbix file and I will look into this.
✨ Follow us on LinkedIn
Learn about conditional formatting at Microsoft Reactor
My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
- themistoklis
Community Champion
I sugget you create bookmarks. So you can create 2 new buttons and assign a bookmark to each one of them
With a bookmark you create a snapshot of the report based on certain rules that you apply to visuals or filters.
1st Bookmark will have filters where all Non-Blank values will be selected
2nd Bookmark will have Blank values selected in filters
