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
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 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.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.