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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
skaranth10
Helper I
Helper I

Duplicate rows on Table Visual

Hi,

I am facing a small problem here in trying to compile a report. It seems quite simple, but I am just not able to get the desired result.

 

I have two tables - OrserUserFields & Orders, which are joined through OrderId on a Many-to-One relationship. 

 

This is what the OrderUserFields table looks like. The OrderIds are repeated for the different LabelPrimarys (It doesn't seem to be repeated on this screenshot, but it actually is.). 

 

skaranth10_0-1602259167990.png

 

I have pivoted this table on LabelPrimary with another field called Values, and chose 'No Aggregation' in the advanced options. 

 

This is what the table looks like after pivoting - 

skaranth10_1-1602259286477.png

 

And here's what my report currently looks like - 

skaranth10_2-1602259351094.png

 

My requirement is to have just one row per OrderID and have the respective values for #Frozen, #Ambient, #PKU, etc. I am currently getting duplicate values on my report, as seen on the screenshot above. What can I do to fix this?

 

Any help would be appreciated. 

 

Regards,

Sanjay

 

5 REPLIES 5
Anonymous
Not applicable

@skaranth10 ,

 

Is it showing the duplicate values in Data Model as well?

And did you removed duplicate rows in Power Query if not required ?

Hi @Anonymous , Regarding the duplicates, the OrderUserFields table has multiple rows with the same OrderId, but deffierent value for each of the columns - #pku, #frozen, etc. 

I haven't touched anything on the Query Editor.  The only thing I have done to the data source is that I have pivoted the PrimaryLabel column on Values (Non-aggregated).  

Hi @skaranth10 ,

 

Try use the orderid in orders table.

Without a sample pbix may not know the exact issue.See if you could share the sample pbix via cloud service like onedrive for business.

Please remove any sensitive data before uploading

 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @V-lianl-msft ,

I have the pbix file ready, but am not sure how I can attach it here. Any way I share it here?

I am not sure how I can share it through Onedrive for business either. 

 

Regards,

Sanjay

Hi @V-lianl-msft ,

I did use the OrderID from the Orders table. It still creates the duplicates for # of Ambient, # of frozen, # of Pkus, etc that I pull into the visual. A duplicate is created for each one of them on the table. 

 

I will work on hiding sensitive info and share the pbix file here in a bit. 

 

Thank you! 

 

Regards,

Sanjay

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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