Fill Gaps in Matrix

[Paco]

I want to fill with 0 when there is no value, how can I do it?

[Phil_Seamark]

Hi @Paco

Adding a +0 to your forumla will sometimes work, but if you don't actually have data for that intersection you have nothing to add 0 to

eg. in your photo, do you have any data for ZGFN-005 for April 2016?  I'm guessing not so you may have to invent some 0 rows to force this. 

[Paco]

I am using a data from SQL Query, so I can´t add or I dont know how to add rows with 0. 

What I want to do is something similar to a pivot table in Excel "For empty cells show" with this option in excel I resolve this but I dont know how to do it in Power BI

don 

[Vvelarde]

@Paco

Hi, What are using in Values Section in The Matrix?.

A Field, a measure?

[Paco]

A field

[Vvelarde · Accepted solution]

@Paco

You can try using a Measure:

MyMeasure=sum(Table[YourField])+0

[Paco]

Thank you very much, it has been solved 

[DoubleJ]

Do you use a measure? If so you can try adding 0 (+0) in your formula.

If you use values from a column you can create a new column referring your existing one and adding 0.

Hope this helps!

JJ