Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Frequent Visitor

Splitting column items into new columns

Hello all,


I have a list like in below (example) and I need to split "Year" column into new columns.

It means, I need to show yearly score of each city in the columns (like 2019-2020-2021-2022-2023)..


But I can't do this with PowerQuery in any way, how can I do it with feature "Add Measure" or "Add New Column" with DAX?




Thank you,


Helper III
Helper III

Do you mean you need to Pivot the table?  Not sure if I am understanding the query correctly? If I am.... Select the year column, then pivot by value 
Pivot 1.PNGpivot 2.PNG 


Helper V
Helper V

Hello Check this out



Helper V
Helper V

Hello @ernum  You can use matrix visual for this
Or you have create different calculated columns as per your requirements.

Hello, thanks for reply.

Actually when I put years to the column of the matrix table, I can get result almost that I wanted.

But when I try to add another information to the column, it's hiding it under the year columns

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors