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
Beth_H
Frequent Visitor

Table Visual is duplicating lines and showing blanks when new fields pulled into table

I have two tables with a single-direction one-to-many relationship, joined on placement[Id] and UserFieldValuePivot[RecordId].

 

Beth_H_0-1720626317961.png

 

The issue is that, when I try to add userfieldvaluepivot fields to a table visual already displaying placement ids, the visual will show two rows per id that has a value in that field - one blank and one with the value.

 

EG Id is from placement, and RecordId and Agency come from UserFieldValuePivot

Beth_H_1-1720626604646.png

 

Is this normal behaviour? Or a bug? I can't work out why a blank row is duplicated. Ideally it would show the id only ONCE for one input for Agency. 

 

For more context, I have made the UserFieldValuePivot table as a pivot of a table called UserFieldValue which pivoted on entity UserFieldValuePivot[Index]. When I previously pivoted around UserFieldValuePivot[RecordId], this issue did not arise.

 

Can anyone help??

 

 

 

 

The many table is a pivot table I created from another table called UserFieldValue.

 

 

2 REPLIES 2
v-kaiyue-msft
Community Support
Community Support

Hi @Beth_H ,

 

Have you solved your problem? If so, can you share your solution here and mark the correct answer as a standard answer to help other members find it faster? Thank you very much for your kind cooperation!

 

 

Best Regards,

Clara Gong

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

vanessafvg
Super User
Super User

your categorical data should always come from the one side and not the many, that is why you have a cartesian.  if you need the agency, it should sit on the one side, otherwise this will happen because the many side will have different results.      but that also depends on what key you used to link these 2 bits data together, the granularity might also be incorrect.





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




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.

July Newsletter

Fabric Community Update - July 2024

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