Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
18 |