Forum Discussion
Solved
Fill Gaps in Matrix
I want to fill with 0 when there is no value, how can I do it?
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.
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