Unable to remove empty (null) values in rows

[TAN_THOMAS]

I currently have a table which displays numerical values as the column data. I used transform data > pivot column to come out with the row header and column values. However, it is displaying 1 unique value for each column which is not what i want as it will result in a very long list of data in a table. I want each row to have different values for each row heading as well. I tried using the fill up and fill down method but it fills the table with value from the row above which is not what I want as this is data inaccuracy. 

For example: 1 row should have values for Test2, Test1, and Test3, instead of each row having unique values. 

[Anonymous]

@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.

[TAN_THOMAS]

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: 

[Ashish_Mathur]

Hi,

Share some data to work with and show the expected result.  Share data in a format that can be pasted in an MS Excel file.

[TAN_THOMAS]

my expected result is just for each row to display data, like the image attached. how each row is displaying unique values only 

[Ashish_Mathur]

Hi,

Share some data to work with and show the expected result.  Share data in a format that can be pasted in an MS Excel file.