Forum Discussion
Unpivot table visual
Hey guys!
I wanted to know, is there a way to pivot a table visual? I have a table that looks like this:
Is there a way to change it IN the visual in order to get something like this?
Attribute - Value
Backlog Grooming - Excellent
Backlog Grooming - Great
Backlog Grooming - Nice
Backlog Grooming - Nice
....
Defect Management Strategy - Nice
Defect Management Strategy - Not found
Defect Management Strategy - Nice
I would normaly do the changes in the data, but I have my table named 'Audit Results': This table has some info coming from an Excel file + my calculated columns:
From my Excel I have column names like these:
And from my power BI I added columns like this also:
What can I do?
12 Replies
Hi Anonymous
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523Hi Anonymous
You can do unpivot from power query.
Steps to follow:
1) select your column to unpivot2) go to transform tab > unpivot > unpivot selected columns
3) it will look like this attribute - value columns
4) save and close
Note: If you dont want other columns so can remove other columns from Power query.
if my post helps please give kudos and accept it as a solution!
ThanksHi Anonymous
I have not asked you to create calculated column. just jo the above steps to pivot your columns.
I am saying if you dont wanted any columns apart from pivot so you can remove it.
