cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper III
Helper III

Hiding blank rows for null categories

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?

Hiding blank lines.png

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

View solution in original post

5 REPLIES 5
Super User III
Super User III

@andrekroker 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.

edhans_0-1598051857569.png

 

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 @pranit828 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. 

 



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

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.

View solution in original post

Super User II
Super User II

HI @andrekroker 

 

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

pranit828_0-1598050077025.png

 





PBI_SuperUser_Rank@1x.png
Hope it resolves your issue? 
Did I answer your question? Mark my post as a solution!

Appreciate your Kudos, Press the thumbs up button!!👍
Linkedin Profile
Continued Contributor
Continued Contributor

@andrekroker 

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.  

Super User IV
Super User IV

@andrekroker , refer if this can help

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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors