How to remove blank values from a horizontal bar chart

[Anonymous]

Hello

I´m working on a project about servers and its errors. In my Y axis I see the name of the servers and in X the count of errors, I also organized them using a TOP 10 so I only see the servers with more errors. However, some cells are blank. and I used a horizontal bar chart to display this. My problem is that the highest number of errors don't have a server associated. I need to "hide" that blank bar and still display the other top 10 without it. 

Hope someone understands my terrible english and can help me.

I cannot use the actual data so here it is a sample I created with random values

Regards.

[Anonymous]

No... And to be honest I'm not really sure how to do it. I searched a bit but didn't understood how can I filter the blank items and also doing the top 10 at the same time.

[Anonymous]

Hello

Do you try the top with allnonblanks ?

[Syk]

You can use a visual level filter to remove the blanks (or nulls).

Just select the visual, find the y-axis value (names of servers) and under basic filtering deselect the blank (or null) value!

[Anonymous]

That would be an amazing answer but unfortunaly as I said im already using a filter there to get the top 10. I don't know why I cannot filter the "count of error" (probably because is a "count" 😕 ). There is anyother way?  

[Syk · Accepted solution]

You can add the same field to the fitlers a second time! In this screenshot, I've added the rating field twice and you can use it to filter out the blanks and get the top 10

[Anonymous]

Ahhh that's exactly what I needed. Thank you very much 🙂