Visual Plotting names of fields that meet a requirement

[Anonymous]

Hi Everyone,

Im working on analyzing Master Data. And I would like to find visual which shows me all those Columns/Fields which meet a requirement. For example, show the names of those fields which have more than 5 different values.

So for instance, given the example data Set, the visual would show (Somehow, maybe with bars and showing the final count, or just the name of the field in the visual way...) F1 and F3

F1       F2     F3

a	a	a
b	a	b
b	a	c
a	a	d
a	b	e
c	b	a
c	b	b
f	b	c
f	b	d
g	b	e
g	b	f
h	b	g
a	c	a
d	c	b

Thank you very much for the help!

[speedramps · Accepted solution]

Please consider this solution and leave kudos ...

In the query editor select all the columns and click Unpivot Columns

Add a table visual, and add attribute and Value Distinct Count to the visual.

Now add a filter to just show Value Distinct Count >= 5