Fabric is Generally Available. Browse Fabric Presentations. Work
towards your Fabric certification with the Cloud Skills Challenge.
I have a data table listing below:
Using this data, I have created a table on PBI Desktop like so:
However I need to change how this is displayed so the 'branch' value is a column and the other values ('tabard' , 'deluxe polo' etc) show as rows (with a total column).
How do I do this? I've tried in power query but the only data I want to show is the totals of these columns.
So on the data table the columns in question are 'Branch' and all other uniform columns containing 'Quantity'
please help !
Go to Solution.
Hi @Jtaylor95 , try this:
- In Power Query select the columns that appear in the image, and choose unpivot other columns:
View solution in original post
Check out the November 2023 Power BI update to learn about new features.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.