cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

How to display fields with missing or no data?

 

Im currrently doing a report that checks specific fields and see if that contains data or not. 

 

 

Field:Contains no data:Contains
data:
Name082.743
Industry Sector1982.724
Phone55.92726.816
Email69.98312.760
Website82.69152

 

 

So i created two measure per field: one that counts blank columns and the other one that counts the column containing data.

My problem is i need to show what are those records having blanks. I used table visual and whenever i click the Blank Phone column, i doesnt filter the table, it just refreshed. 

 

OrganizationBlank NamesNames with DataBlank PhonePhone with Data
A0,0027581,0043234,001450,00
B0,0034290,00231,005692,00
C0,0020872,0012462,0019674,00

 

 

 

1 REPLY 1
v-viig
Community Champion
Community Champion

It seems this issue is not related to Custom Visuals.

Please create a new topic here.

 

Ignat Vilesov,

Software Engineer

 

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors
Top Kudoed Authors