Forum Discussion
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: |
| Name | 0 | 82.743 |
| Industry Sector | 19 | 82.724 |
| Phone | 55.927 | 26.816 |
| 69.983 | 12.760 | |
| Website | 82.691 | 52 |
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.
| Organization | Blank Names | Names with Data | Blank Phone | Phone with Data |
| A | 0,00 | 27581,00 | 43234,00 | 1450,00 |
| B | 0,00 | 34290,00 | 231,00 | 5692,00 |
| C | 0,00 | 20872,00 | 12462,00 | 19674,00 |
1 Reply
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
