Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
We have a database that uses empty values and need to filter them out. How to filter all records using an empty value in the Report view?
If I understand, there is value, but how to filter the empty value?
Hi @toplisek ,
As we haven’t heard back from you, so just following up to our previous message. I'd like to confirm if you've successfully resolved this issue or if you need further help.
If yes, you are welcome to share your workaround and mark it as a solution so that other users can benefit as well. If you find a reply particularly helpful to you, you can also mark it as a solution.
If you still have any questions or need more support, please feel free to let us know. We are more than happy to continue to help you.
Thank you for your patience and look forward to hearing from you.
Best Regards,
Chaithra E.
Hi @toplisek ,
May I ask if you have gotten this issue resolved?
If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.
Regards,
Chaithra.
If you dont know how to filter yet then you are clearly a novice.
Please do some basic training before asking question.
You will learn quicker and better by doing structured traning rather than asking random basic questions here.
https://www.youtube.com/watch?v=AGrl-H87pRU
and here
https://learn.microsoft.com/en-gb/training/modules/get-started-with-power-bi/
You need to determine if empty values are null, spaces and/or zeros.
There are several way to filter:-
Please click thumbs uip because I have tried to help.
Then click [accept solution] if this solves your problem (it will).
Hi @toplisek ,
Not sure what you mean to filter all empty values, if it's only a specific column or several columns, but it seems that you need to use the filter pane to filter out the values on the specific field you have check the documentation below.
https://learn.microsoft.com/en-us/power-bi/consumer/end-user-report-filter
In this specific case you will probably need to apply this to the all page.
If you need any more assistance please give some more context.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsCheck out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
74 | |
71 | |
38 | |
29 | |
26 |
User | Count |
---|---|
97 | |
96 | |
60 | |
44 | |
41 |