Data Missing when Convert Table Visual to Matrix Visual

[Anonymous]

Could anyone help on this? Thanks.

I have Table Visual as follows

when I convert it a Matrix Visual shown as below, the highlighed row data are missing. I don't have any additional filters applied on the Matrix Visual.

[v-gizhi-msft]

Hi,

According to your description, I create a table to test:

Choose a table visual:

Then, choose a matrix visual:

It shows the correct result.

So, for your problem, please move [DeviceID] to matrix rows to check whether it still lose the last row:

And please share your pbix file with me by OneDrive here and remember to remove sensitive data.

Best Regards,

Giotto Zhi

[Anonymous · Accepted solution]

Thanks, Giotto.

When I move  [DeviceID] to matrix rows no data missing was observed. I some kind of found the problem cause.

I have defined a measure 

FeederSlicer = if(min(DeviceOperationsBy2Step[DeviceFeeder]) in values(FeederList[FeederID]) || min(DeviceOperationsBy2Step[DeviceAltFeeder]) in values(FeederList[FeederID]),1,0)

I used it to filter the table based on two columns [DeviceFeeder] and [DeviceAltFeeder]. This masure has been applied on both the Table Visual and Matrix Visual. However, for Matrix Visual, it seems this measure is not calculated like cell by cell.

I found one workaround is to have both DeviceID in Rows and Columns.

Not sure how to share the file. It is pretty big.

Thanks again.