Forum Discussion
Creating a Matrix format in the Query Editor
You can use "GROUPBY" operation before doing pivoting to achieve waht you are looking for.
You can use pivot columns feature to achieve the desired matrix format result. However, there is already a inbuilt matrix visualization in powerbi (next to the table visual) that can be used as well.
For the transformation in Query Editor, Select the stage column and choose pivot column. As shown in the screenshot, Values section should be amount and aggrgation must be SUM to achieve expected output.
PIVOTOUTPUT
If account name was the same lets say there is "A" and the amount is 1000 in Value Validation and another time "A" and the amount 4000 in Value Validation how do you connect both of them?
or in the case where an account has one opportunity at Value Validation and another at Business Lost, how do you connect them?
You can use "GROUPBY" operation before doing pivoting to achieve waht you are looking for.
