topic How to display fields with missing or no data? in Custom Visuals Development Discussion https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/How-to-display-fields-with-missing-or-no-data/m-p/410087#M999 <P>&nbsp;</P><P>Im currrently doing a report that checks specific fields and see if that contains data or not.&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><TABLE><TBODY><TR><TD><SPAN>Field:</SPAN></TD><TD><SPAN>Contains no data:</SPAN></TD><TD><SPAN>Contains<BR />data:</SPAN></TD></TR><TR><TD><SPAN>Name</SPAN></TD><TD><SPAN>0</SPAN></TD><TD><SPAN>82.743</SPAN></TD></TR><TR><TD><SPAN>Industry Sector</SPAN></TD><TD><SPAN>19</SPAN></TD><TD><SPAN>82.724</SPAN></TD></TR><TR><TD><SPAN>Phone</SPAN></TD><TD><SPAN>55.927</SPAN></TD><TD><SPAN>26.816</SPAN></TD></TR><TR><TD><SPAN>Email</SPAN></TD><TD><SPAN>69.983</SPAN></TD><TD><SPAN>12.760</SPAN></TD></TR><TR><TD><SPAN>Website</SPAN></TD><TD><SPAN>82.691</SPAN></TD><TD><SPAN>52</SPAN></TD></TR></TBODY></TABLE><P>&nbsp;</P><P>&nbsp;</P><P>So i created two measure per field: one that counts blank columns&nbsp;and the other one that counts the column containing data.</P><P>My problem is i need to show what are those records having blanks. I used table visual and whenever i click the <STRONG>Blank Phone</STRONG> column, i doesnt filter the table, it just refreshed.&nbsp;</P><P>&nbsp;</P><TABLE><TBODY><TR><TD><SPAN>Organization</SPAN></TD><TD>Blank Names</TD><TD>Names with Data</TD><TD>Blank Phone</TD><TD>Phone with Data</TD></TR><TR><TD>A</TD><TD>0,00</TD><TD><SPAN>27581,00</SPAN></TD><TD>43234,00</TD><TD>1450,00</TD></TR><TR><TD>B</TD><TD>0,00</TD><TD>34290,00</TD><TD>231,00</TD><TD>5692,00</TD></TR><TR><TD>C</TD><TD>0,00</TD><TD>20872,00</TD><TD>12462,00</TD><TD>19674,00</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Thu, 03 May 2018 15:39:14 GMT Anonymous 2018-05-03T15:39:14Z How to display fields with missing or no data? https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/How-to-display-fields-with-missing-or-no-data/m-p/410087#M999 <P>&nbsp;</P><P>Im currrently doing a report that checks specific fields and see if that contains data or not.&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><TABLE><TBODY><TR><TD><SPAN>Field:</SPAN></TD><TD><SPAN>Contains no data:</SPAN></TD><TD><SPAN>Contains<BR />data:</SPAN></TD></TR><TR><TD><SPAN>Name</SPAN></TD><TD><SPAN>0</SPAN></TD><TD><SPAN>82.743</SPAN></TD></TR><TR><TD><SPAN>Industry Sector</SPAN></TD><TD><SPAN>19</SPAN></TD><TD><SPAN>82.724</SPAN></TD></TR><TR><TD><SPAN>Phone</SPAN></TD><TD><SPAN>55.927</SPAN></TD><TD><SPAN>26.816</SPAN></TD></TR><TR><TD><SPAN>Email</SPAN></TD><TD><SPAN>69.983</SPAN></TD><TD><SPAN>12.760</SPAN></TD></TR><TR><TD><SPAN>Website</SPAN></TD><TD><SPAN>82.691</SPAN></TD><TD><SPAN>52</SPAN></TD></TR></TBODY></TABLE><P>&nbsp;</P><P>&nbsp;</P><P>So i created two measure per field: one that counts blank columns&nbsp;and the other one that counts the column containing data.</P><P>My problem is i need to show what are those records having blanks. I used table visual and whenever i click the <STRONG>Blank Phone</STRONG> column, i doesnt filter the table, it just refreshed.&nbsp;</P><P>&nbsp;</P><TABLE><TBODY><TR><TD><SPAN>Organization</SPAN></TD><TD>Blank Names</TD><TD>Names with Data</TD><TD>Blank Phone</TD><TD>Phone with Data</TD></TR><TR><TD>A</TD><TD>0,00</TD><TD><SPAN>27581,00</SPAN></TD><TD>43234,00</TD><TD>1450,00</TD></TR><TR><TD>B</TD><TD>0,00</TD><TD>34290,00</TD><TD>231,00</TD><TD>5692,00</TD></TR><TR><TD>C</TD><TD>0,00</TD><TD>20872,00</TD><TD>12462,00</TD><TD>19674,00</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Thu, 03 May 2018 15:39:14 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/How-to-display-fields-with-missing-or-no-data/m-p/410087#M999 Anonymous 2018-05-03T15:39:14Z Re: How to display fields with missing or no data? https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/How-to-display-fields-with-missing-or-no-data/m-p/410703#M1001 <P>It seems this issue is not related to Custom Visuals.</P> <P>Please create a new topic <A href="http://community.powerbi.com/t5/Desktop/bd-p/power-bi-designer" target="_blank">here</A>.</P> <P>&nbsp;</P> <P style="margin: 0in; font-family: Calibri; font-size: 11.0pt; color: #333333;">Ignat Vilesov,</P> <P style="margin: 0in; font-family: Calibri; font-size: 11.0pt; color: #333333;">Software Engineer</P> <P style="margin: 0in; font-family: Calibri; font-size: 11.0pt; color: #333333;">&nbsp;</P> <P style="margin: 0in; font-family: Calibri; font-size: 11.0pt; color: #333333;">Microsoft Power BI Custom Visuals</P> <P style="margin: 0in; font-family: Calibri; font-size: 11.0pt;"><A href="mailto:pbicvsupport@microsoft.com" target="_blank"><SPAN>pbicvsupport@microsoft.com</SPAN></A></P> Fri, 04 May 2018 09:57:20 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/How-to-display-fields-with-missing-or-no-data/m-p/410703#M1001 v-viig 2018-05-04T09:57:20Z