cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
flowcalculator
Frequent Visitor

Data Missing when Convert Table Visual to Matrix Visual

Could anyone help on this? Thanks.

I have Table Visual as follows

Table.jpg

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.

Matrix.jpg

 
1 ACCEPTED SOLUTION

Accepted Solutions
flowcalculator
Frequent Visitor

Re: Data Missing when Convert Table Visual to Matrix Visual

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.
 
 
 
 

 

View solution in original post

2 REPLIES 2
Microsoft v-gizhi-msft
Microsoft

Re: Data Missing when Convert Table Visual to Matrix Visual

Hi,

 

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

21.png

Choose a table visual:

22.png

Then, choose a matrix visual:

23.png

It shows the correct result.

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

24.png

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

 

 

Best Regards,

Giotto Zhi

flowcalculator
Frequent Visitor

Re: Data Missing when Convert Table Visual to Matrix Visual

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.
 
 
 
 

 

View solution in original post

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors