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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

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
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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