cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
gabrielvoz
New Member

Substituir células vazias de um matriz pelo valor 0

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.

4 REPLIES 4
v-evelk
Microsoft
Microsoft

Hello,

 

Do you mean core Matrix visual of Power BI?

Could you please provide some screenshots to better understand your issue?

 

Kind Regards,

Evgenii Elkin,
Software Engineer
Microsoft Power BI Custom Visuals
pbicvsupport@microsoft.com

 

exemplo.png

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.

Ok, got it!

I will ask an appropriate team for comments and provide answer here as son as I receive it.

 

Kind Regards,

Evgenii Elkin,
Software Engineer
Microsoft Power BI Custom Visuals
pbicvsupport@microsoft.com

The feature is in a visual backlog but there isn't any ETA regarding when it will be implemented.

 

However, there is a following workaround that was provided by developers:

 

"The most common workaround is to update your measure to avoid blanks or create a new calc column that turns blanks into zero.

https://community.powerbi.com/t5/Desktop/show-items-with-no-data-as-0-instead-of-blanks/td-p/113160

 

New column:

MeasureNoBlanks =
IF (
    CALCULATE ( SUM ( Expenses[Actual] ) ) = BLANK (),
    0,
    CALCULATE ( SUM ( Expenses[Actual] ) )
)

 

Updated Measure (+ 0):

Measure = CALCULATE ( SUM (table[column] ), FILTER (... ) ) + 0

"

 

I hope, that it will help.

 

Kind Regards,

Evgenii Elkin,
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 on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Top Solution Authors