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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors