Hiding blank rows for null categories

[Anonymous]

Hi all()

I want to remove thes 2 blank lines and show de values of "0", "40.0" and "32.2" for the "Product Category".

Why is powerbi showing these 2 "null" or "empty" categories?

[edhans]

@Anonymous if you want to remove them from your data completely, if you go back to Transform Data and find those numeric fields, hit thie FILTER button and uncheck the null value. If it is a text field it wll show (blanks) instead of (null). You can uncheck for those as well.

Otherwise, @swise001 brings up a valid point. If you have items in your data that are not in the dimension table, Power BI will create the blanks. You can remove those from your measures using functions like ALLNOBLANKROW(), but I'd need to see some data to actually help with that.

And @Anonymous has shown a way to just filter them from a specific visual, but they will impact other visuals or aggregations, like COUNTROWS, AVERAGE, etc.

So it just depends on what you are trying to do. Let us know if these still haven't answered your question. Otherwise, please mark one or more as the solution and give a Kudos/Thumbs Up to those that helped. 

[Anonymous · Accepted solution]

Guys

Thank you all for responses. I ended up adding 2 more data cleansing rows in the query editor in order to correctly clean lines with null comments and lines with null categories.

[Anonymous]

HI @Anonymous 

Create filters on all the columns to say "is not blank"

[swise001]

@Anonymous 

Usually - null categories like you're showing are artifacts of the relatonships.   Perhaps there are some rogue items that don't have a corresponding match in your lookup table.  

[amitchandak]

@Anonymous , refer if this can help

https://www.inkeysolutions.com/blogs/power-bi-hide-null-or-blank-values-in-matrix-visual/