The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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!
Solved! Go to 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
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
User | Count |
---|---|
28 | |
12 | |
8 | |
7 | |
5 |
User | Count |
---|---|
35 | |
14 | |
12 | |
9 | |
7 |