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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors