empty cells appear in table in visualization part
hi everyone I have a problem; I have two related tables and I visualized them in a table in visualization part in power bi rs...in this table I have put a column for the codes of goods and a column for the amount of those codes remaining in the factory warehouse...the problem is when I visualize them in this table I have 3 rows that have a number for remaining goods but the codes part is empty...i have checked the source table and there is no row with no codes...what is the problem?
Replacing null with zero brings extra rows to the matrix
I have a requirement to replace null with zero inside the matrix. I have two metrics and two dimensions and the data is at the monthly level. I have already replaced null with zero in the Power Query, but as seen below the values still appear as null. I have been trying a few approaches recommended in the Community: - Adding +0 to the measure - Use if(isblank(measure), 0, measure) - Use COALESCE(measure, 0) Each of those techniques replaces nulls with zeros, however, this is being done for all the values in the database. It is resulting in bringing many extra rows to my matrix along with very poor performance. Example below: Is there any way to inject "0" in my matrix without bringing extra rows?How to replace empty cells in matrix with another value?
Grettings, I'm trying to fill this empty cells on this table with the value "100%". I've already applied "ISBLANK" and "+0" at the end of the formula. Is there any other way to fill these cells? The values "%" showed are a calcutated column of two measures.
