Forum Discussion
Matrix with 2 value columns
- 8 years ago
Oh my gosh....I'm not sure what I was doing but it's working now.
Thank you for your responses to help make my brain engage...:smileyfrustrated: :smileyvery-happy:
I have a subset of the data that I'm playing with to try and replicate from the pivot table to the Matrix within Power BI. There aren't any measures to create other than the sums of values in a column.. I'm summing those values grouped on the left by Dept's and across the top, breaking it out by Year breaking down even further by Qtr.
Does this help? In the image Dept & Desc. are represented as the rows in the pivot table (SAP Module and TCode Desc). The columns across the top of the pivot table are breaking the summed values down by date (in my case Year, QTR). The summed values are the fields showing.