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
JustNewbie
Helper I
Helper I

Unpivot table

Hi, 

Currently Table 2 is connected to Table 1. Relationship is One to Many (Table 2 Reference is unique, Table 1 Reference will duplicate.) Now I want to unpivot Column F,G,H,I in Table 2. Problem here is if I unpivot, the reference number in Table 2 will become duplicate and not unique, it affects my Table relationship become many to many. Result will incorrectly display when I create visuals. How do I solve this issue?

 

JustNewbie_0-1688622791592.png

 

1 ACCEPTED SOLUTION
Dhairya
Solution Supplier
Solution Supplier

Hey @JustNewbie 


If you are using Table 2 as a slicer then as a workaround you can take a duplicate of Table 2 and unpivot that duplicate table so your Table2(older one without unpivot) will have 1 to many relationships with Table 1 and Duplicate of Table, So by this way you handle this.

If this works for you then please mark my solution as accepted so that it can help others too. Thank you!

View solution in original post

4 REPLIES 4
Dhairya
Solution Supplier
Solution Supplier

Hey @JustNewbie 


If you are using Table 2 as a slicer then as a workaround you can take a duplicate of Table 2 and unpivot that duplicate table so your Table2(older one without unpivot) will have 1 to many relationships with Table 1 and Duplicate of Table, So by this way you handle this.

If this works for you then please mark my solution as accepted so that it can help others too. Thank you!

thanks, does it means I need to have table 2 & duplicate table 2 connected to Table 1? 

No relationship will be like
table2    1 to many      table1
table2    1 to many      table2 duplicate(unpivoted)

Hey @JustNewbie 

If this works for you then please mark my solution as accepted so that it can help others too. Thank you!

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.

Top Solution Authors