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

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.

Reply
harib
Post Patron
Post Patron

Double values are coming when i go for Unpivot

Hello Friends

 

When we unpivot the columns values are doubling . Can't we show the before unpivot value like 40  in unpivot table  instead of showing the 120. And do we get any performance issues with Unpivot data because of multiple values. Please let me know. For more understanding i have given pictures.

 

Before Unpivot

 8.PNG

 

After Unpivot

9.PNG

Thanks in Advance if anyone give clarity on this.

2 REPLIES 2
v-xicai
Community Support
Community Support

Hi @harib ,

 

You need to show the 40 in place mark1 or in place mark2?  Could you please share your desired output screenshots for further analysis?

 

5.png

 

 

 

 

 

 

 

 

 

Best Regards,

Amy

@v-xicai 

 

Thanks for you responce. Due to busy with someother work i didn't see your post. ActuallyI want to show 40 in place of Mark 2. If it's possible kindly give me the solution

 

Thanks in advance

 

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors