acrobertsFrequent Visitor9 years agoSolvedMatrix/Pivot Question Hello, I am trying to create a Power BI Matrix from sales data that looks like: To create a summary, by sales person, by count of their role in a sale: I'm probably overth...Show MoreVvelarde9 years agoacroberts Hi, in Edit Query Select the 3 columns (Except Opp ID) and Transform Unpivot Columns. You'll obtain something like this: Change the name of the Columns. Close & Apply Finally in a Matrix
Vvelarde9 years agoacroberts Hi, in Edit Query Select the 3 columns (Except Opp ID) and Transform Unpivot Columns. You'll obtain something like this: Change the name of the Columns. Close & Apply Finally in a Matrix
Vvelarde9 years agoacroberts Hi, in Edit Query Select the 3 columns (Except Opp ID) and Transform Unpivot Columns. You'll obtain something like this: Change the name of the Columns. Close & Apply Finally in a Matrix
VvelardeCommunity Champion9 years agoacroberts Hi, in Edit Query Select the 3 columns (Except Opp ID) and Transform Unpivot Columns. You'll obtain something like this: Change the name of the Columns. Close & Apply Finally in a Matrix
acrobertsFrequent Visitor to Vvelarde9 years agoAh, yes Vvelarde - that did the trick! Thanks so much :)
acrobertsFrequent Visitor to Vvelarde9 years agoAh, yes Vvelarde - that did the trick! Thanks so much :)
Related contentBookmark questionsArchitecture question and brainstormingUnpivot QuestionField Parameter QuestionLicense Questions
