https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Substituir-c%C3%A9lulas-vazias-de-um-matriz-pelo-valor-0/m-p/774457#M2458 <P>Hello,</P><P>&nbsp;</P><P>Do you mean core Matrix visual of Power BI?</P><P>Could you please provide some screenshots to better understand your issue?</P><P>&nbsp;</P><P>Kind Regards,</P><P>Evgenii Elkin,<BR />Software Engineer<BR />Microsoft Power BI Custom Visuals<BR />pbicvsupport@microsoft.com</P><P>&nbsp;</P> Fri, 23 Aug 2019 14:53:06 GMT v-evelk 2019-08-23T14:53:06Z https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Substituir-c%C3%A9lulas-vazias-de-um-matriz-pelo-valor-0/m-p/770975#M2444 <P>Seria ótimo se existisse a opção de substituir as células vazias de uma matriz pelo valor 0, pois muitas vezes quando uma matriz é alimentada por uma Query, algumas células ficam vazias e isso acaba gerando dúvidas nas pessoas que vizualizam o realtórios por não saberem do que se trata essas células vazias.</P> Tue, 20 Aug 2019 13:58:38 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Substituir-c%C3%A9lulas-vazias-de-um-matriz-pelo-valor-0/m-p/770975#M2444 gabrielvoz 2019-08-20T13:58:38Z https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Substituir-c%C3%A9lulas-vazias-de-um-matriz-pelo-valor-0/m-p/774457#M2458 <P>Hello,</P><P>&nbsp;</P><P>Do you mean core Matrix visual of Power BI?</P><P>Could you please provide some screenshots to better understand your issue?</P><P>&nbsp;</P><P>Kind Regards,</P><P>Evgenii Elkin,<BR />Software Engineer<BR />Microsoft Power BI Custom Visuals<BR />pbicvsupport@microsoft.com</P><P>&nbsp;</P> Fri, 23 Aug 2019 14:53:06 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Substituir-c%C3%A9lulas-vazias-de-um-matriz-pelo-valor-0/m-p/774457#M2458 v-evelk 2019-08-23T14:53:06Z https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Substituir-c%C3%A9lulas-vazias-de-um-matriz-pelo-valor-0/m-p/776894#M2474 <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="exemplo.png" style="width: 956px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/187959i5A586E74084D208E/image-size/large?v=v2&amp;px=999" role="button" title="exemplo.png" alt="exemplo.png" /></span></P><P>Esse é o resultado de minha matriz em que os dados estão vindo de uma consulta sql, após cruzar os dados os campos vazios não apresentam nenhum valor, assim como na imagem, o meu desejo é que ao invès do campo ficar vazio, apresentace valor 0 de forma automática.</P> Tue, 27 Aug 2019 13:54:34 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Substituir-c%C3%A9lulas-vazias-de-um-matriz-pelo-valor-0/m-p/776894#M2474 gabrielvoz 2019-08-27T13:54:34Z https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Substituir-c%C3%A9lulas-vazias-de-um-matriz-pelo-valor-0/m-p/779323#M2485 <P>Ok, got it!</P><P>I will ask an appropriate team for comments and provide answer here as son as I receive it.</P><P>&nbsp;</P><P>Kind Regards,</P><P>Evgenii Elkin,<BR />Software Engineer<BR />Microsoft Power BI Custom Visuals<BR />pbicvsupport@microsoft.com</P> Thu, 29 Aug 2019 15:49:47 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Substituir-c%C3%A9lulas-vazias-de-um-matriz-pelo-valor-0/m-p/779323#M2485 v-evelk 2019-08-29T15:49:47Z https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Substituir-c%C3%A9lulas-vazias-de-um-matriz-pelo-valor-0/m-p/783606#M2505 <P>The feature is in a visual backlog but there isn't any ETA regarding when it will be implemented.</P><P>&nbsp;</P><P>However, there is a following workaround that was provided by developers:</P><P>&nbsp;</P><P>"The most common workaround is to update your measure to avoid blanks or create a new calc column that turns blanks into zero.</P><P><A href="https://nam06.safelinks.protection.outlook.com/?url=https%3A%2F%2Fcommunity.powerbi.com%2Ft5%2FDesktop%2Fshow-items-with-no-data-as-0-instead-of-blanks%2Ftd-p%2F113160&amp;data=02%7C01%7Cv-evelk%40microsoft.com%7Cd9cc77bcb33e48ab9c5d08d7313ac5dd%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C637032000818872428&amp;sdata=I3FSTYWCqA4BJ3sOHZdKw81%2FEHSVg9Q1JzK3q55szlQ%3D&amp;reserved=0" target="_blank">https://community.powerbi.com/t5/Desktop/show-items-with-no-data-as-0-instead-of-blanks/td-p/113160</A></P><P>&nbsp;</P><P>New column:</P><PRE>MeasureNoBlanks = IF ( &nbsp;&nbsp;&nbsp; CALCULATE ( SUM ( Expenses[Actual] ) ) = BLANK (), &nbsp;&nbsp;&nbsp; 0, &nbsp;&nbsp;&nbsp; CALCULATE ( SUM ( Expenses[Actual] ) ) )</PRE><P>&nbsp;</P><P>Updated Measure (+ 0):</P><PRE>Measure = CALCULATE ( SUM (table[column] ), FILTER (... ) ) + 0</PRE><P>"</P><P>&nbsp;</P><P>I hope, that it will help.</P><P>&nbsp;</P><P>Kind Regards,</P><P>Evgenii Elkin,<BR />Software Engineer<BR />Microsoft Power BI Custom Visuals<BR />pbicvsupport@microsoft.com</P><P>&nbsp;</P> Wed, 04 Sep 2019 13:30:51 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Substituir-c%C3%A9lulas-vazias-de-um-matriz-pelo-valor-0/m-p/783606#M2505 v-evelk 2019-09-04T13:30:51Z