Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Rows repeating/duplicating in matrix layout

Hello community,

 

I have been struggling to fix an issue with rows duplicating in my matrix layout. Following is the snapshot of the matrix: 

Rows in column qualification are repeating for each entry of "Allocation percentage of other cost centres" column.

 

Capture_repeating right table.PNG

 

The data on this matrix is sourced from 3 tables - Emp, cost centres & Emp_qualification that are left joined.

Any help in resolving this issue is much appreciated.

 

thanks,

Meena

 

8 REPLIES 8
Ashish_Mathur
Super User
Super User

Hi,

Drag a measure to the value area section of the Matrix visual.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Anonymous
Not applicable

@Ashish_Mathur  thanks for your suggestion. But it doesn't work as it picks up the first qualification only and still repeats for each row.

To add to the info I provided about the matrix, all the columns are actually rows on the matrix.

Hi,

Share the link from where i can download your PBI file.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Anonymous
Not applicable

@Ashish_Mathur  any update?

Hi,

When i drag Cost Account ID to the value area section, i do not see that repetition

Untitled.png

 


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Anonymous
Not applicable

@Ashish_Mathur thanks for trying. But qualification & major are still duplicating. The highlighted "qualification" & "major" should populate only once, irrespective of the number of "other cost centres"

 

Capture_still repeat.PNG

That is the way it works.  As long as there is a number in the value column, the entries in that column will repeat.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Anonymous
Not applicable

@Ashish_Mathur  here is the link: I created a test PBI as my data has sensitive info.

 

https://1drv.ms/u/s!AopNnMaStwKOaQtziQr7RqvXYfc?e=Kk1z1P

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.