Forum Discussion
How to filter all records using empty value?
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 ,
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.
5 Replies
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.
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:-
- Power query https://learn.microsoft.com/en-us/power-query/filter-values
- Filter pane https://learn.microsoft.com/en-us/power-bi/consumer/end-user-report-filter
- Slicers https://learn.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-slicers?tabs=powerbi-desktop
Please click thumbs uip because I have tried to help.
Then click [accept solution] if this solves your problem (it will).
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.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.
