How to filter all records using empty value?

[toplisek]

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?

[speedramps]

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-deskt...

Please click thumbs uip because I have tried to help.

Then click [accept solution] if this solves your problem  (it will).

[MFelix]

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.