Removing column with zero value in diagram after sorting

[ChrisNCFC]

Hi guys. 

Probably a noob question, but I have a presentation where I have three tables on a page. When I press one value on one graph, the other ones are highliting relevant values. This is all brilliant, but I am working with a dataset of 80K lines, so some values are small and hard to find amongst all others. Is it possible to make Power BI automatically remove the columns with no value, and thus only show relevant coloumns? 

Wow, this was difficult to explain 😕 

I have two images attached below. 

In "Data1" all columns have strong colour

In "Data 2" Column 10 in the left graph has been marked, and in top right graph, it has corresponding values in column number 17 and 31, and in column 4, 5 and 23 in the lower graph. 

Can PowerBI automatically remove all the columns that has no value, and similarly readjust if chosing a different option on the graph to the left? 

Does this make sense?

[lbendlin]

The other day someone came up with an ingenious way to create a reverse Pareto with the help of PERCENTILEX.  If your value is above the 20 percentile then use it as is, and otherwise group it under "Other" or suppress it altogether. That way you can tame the Long Tail.

[ChrisNCFC]

Thanks! I looked into it, didn't quite get it- but think I'll find an easier solution for now (I'm a noob in this :-D)

However, the interesting bit is that when right clicking the colums, and as to look at the table i get the exact information presented. All lines with a value are presented, and every line without has been removed. So PowerBI har proven the correct extraction has been done- just need the visuals to match up. *sigh*