Forum Discussion
Unable to remove empty (null) values in rows
Ashish_Mathur , thanks for your concern about this case. Please allow me to offer an insight:
Hi TAN_THOMAS ,
If your data is like the sample data I created, with different groups, according to Power BI design, as long as there is one non-null data point in a row, then the entire row of data will be displayed. If the entire row of data is null, you can click on ‘Show items with no data’ to hide it. Furthermore, each group will have independent values for [Test1], and the value for [Test2] in Group1 will not be automatically filled in if [Test1] in Group1 is null.
If my explanations don't meet your expected results or don't understand your question, can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data. We can better understand the problem and help you
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I used pivot column (Transform > Pivot Column) to make each row header and column header to be values that I want. However, power BI automatically fills in the null values for rows that the value dont tally.
I cannot use replace null values directly because the replacement will lead to inputing a value, leading to data inaccuracy.
I have also tried Fill down and Fill Up for Column1 and Column2 but it fills the data with value from the next row which also leads to data inaccuracy.
It will lead to my table like this which is not what I want.
I want the data to be like that: