how to convert column names and values in to single column as row level values?

[sb_powerbi]

Hello Team,

Thanks for spending time to read my post. I need to help to resolve my issue.

I have excel sheet data which contains Column names Sale Rep,Q1,Q2,Q3,Q4 with data. I want to convert all the Column names with Row level data. Please see the screen shot wiht examples.

IN Power BI I want to show the quarter names in X axis and Sales amount in Y axis. I want to add the Quarter into drill down of Sales Rep field.

It would be great help if i can get any suggestions.

Thanks,

[MarcelBeug · Accepted solution]

Select the Sales Rep column first and the choose unpivot other columns.