Hide blank values in table

[Anonymous]

Hi Community!

I have a table of 3 columns. I don't want to show rows that have the last column blank.

I did not selecteed "Show items with no data":

Also I tried using the page level filter, not selecting Blank:

But, as you see in both screenshots, the rows with no value are still shown.
Any ideas???
Thanks!

[Anonymous · Accepted solution]

Somehow, the data that were shown as blank in the Power BI desktop were transformed to 0 in the service.

I edited the filters in the service report, filtering out the 0, and it was solved.

Thanks!

[Mariusz]

Hi @Anonymous 

I the below is the issue its probobly " " as Space or something in your dataset

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.

[Anonymous]

Seems like whatever is in the Values column is not really blank  (even though it may look like that to us). Maybe do some clean up in Power Query?  

[Anonymous]

If it would be something else (for example NULL), it should appear in the filter, not? but in the filter there only option that is not a value is blank.

[v-lili6-msft]

hi, @Anonymous 

Please check the [Value] field if there is "space" value in this "blank" value.

If you still have the problem, please share a simple pbix file for us have a test.

Best Regards,

Lin

[Mariusz]

HI @Anonymous 

Check the data filed, you can trim it and clean it in query editor, this should do the trick.

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.