Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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.
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
Hi,
Drag a measure to the value area section of the Matrix visual.
@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.
Hi,
When i drag Cost Account ID to the value area section, i do not see that repetition
@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"
That is the way it works. As long as there is a number in the value column, the entries in that column will repeat.
@Ashish_Mathur here is the link: I created a test PBI as my data has sensitive info.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
76 | |
74 | |
57 | |
38 | |
33 |
User | Count |
---|---|
71 | |
65 | |
58 | |
50 | |
47 |