Forum Discussion
Solved
Formatting a matrix
Hello, I need to reply this Google Analytics in Power BI. I don't know how to show columns in groups like ('Adquisición', 'Comportamiento', etc). How can I do it in Power BI? GA Matrix: ...
If we have a Table1 like below, we can select the last 4 columns and click “Unpivot Columns” in Query Editor.
Then duplicate Table1 and remove columns of Paris and Value. Remove duplicates for the Attribute column in Table2.
Add a conditional column like below.
Close and apply Query Editor. Create relationship between Table1 and Table2 with Attribute key. Drag table columns into Matrix as below.
Best Regards,
Herbert
Could you please describe more about “the values og the measures don't split”? What is the expected result of them?
Best Regards,
Herbert
I didn´t remember the problem, but it is solved now, thanks!