Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Data Missing when Convert Table Visual to Matrix Visual

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 ap...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    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.
     
     
     
     

     

v-gizhi-msft's avatar
v-gizhi-msft
Community Support
6 years ago

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's avatar
    Anonymous
    Not applicable
    6 years ago

    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.