Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
Anonymous
Not applicable

Visual Plotting names of fields that meet a requirement

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

aaa
bab
bac
aad
abe
cba
cbb
fbc
fbd
gbe
gbf
hbg
aca
dcb

 

Thank you very much for the help!

1 ACCEPTED SOLUTION
speedramps
Super User
Super User

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

View solution in original post

1 REPLY 1
speedramps
Super User
Super User

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

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.