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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
Duinhir
New Member

Separate in columns repetitive attribute

Good afternoon,

 

i hope you can help me. To correctly link parameters to equivalent in the model I separated using "split column" the year from the three elements QTY, Av. net sell and Turnover.

Now I would need to separate in three different columns: QTY, Av. net sell. and Turnover, so that for each Part number and each year I have the three values, but in independent columns.

Is there a command to do so?

 

Split columns.png

Thank you very much!!!

Fabio

 

 

1 ACCEPTED SOLUTION
Joe_Barry
Super User
Super User

Hi @Duinhir 

 

Highlight the Attribute.2 column, go to the Tranform tab in the ribbon then choose Pivot column. Use the Value column in the Value field. In Advanced Options, Choose Don't Aggregate

 

Hope this helps

Joe




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





Learn about the Star Schema, it will solve many issues in Power BI!

Date tables help! Learn more



LinkedIn
Let's connect on LinkedIn


View solution in original post

1 REPLY 1
Joe_Barry
Super User
Super User

Hi @Duinhir 

 

Highlight the Attribute.2 column, go to the Tranform tab in the ribbon then choose Pivot column. Use the Value column in the Value field. In Advanced Options, Choose Don't Aggregate

 

Hope this helps

Joe




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





Learn about the Star Schema, it will solve many issues in Power BI!

Date tables help! Learn more



LinkedIn
Let's connect on LinkedIn


Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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