cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Cathryn Member
Member

Matrix with 2 value columns

Is this possible?  

 

I'm taking an Excel Pivot table that someone created and converting it to a Power BI Report.  It's reporting a pivot table that is grouped by State and City on the left hand side which is fine and works great as a drill down by row.

 

Then, the Excel workbook has 2 to 3 different counts grouped by Year.

 

I can get the matrix to work for 1 calculated value but I can't show 2 calculated values like you can in Excel.  Maybe I don't have it set up correctly?  I don't want to drill down to the 2nd value in the columns.

 

Does this make sense?

 

Thanks!


Cathryn

1 ACCEPTED SOLUTION

Accepted Solutions
Cathryn Member
Member

Re: Matrix with 2 value columns

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...Smiley Frustrated Smiley Very Happy

7 REPLIES 7
Moderator v-yuezhe-msft
Moderator

Re: Matrix with 2 value columns

@Cathryn,

It is difficult for us to give you suggestions based on your description. Could you please share sample data of the table you imported into Power BI and post expected result here?

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cathryn Member
Member

Re: Matrix with 2 value columns

 

Capture.JPG

 This is coming from an Excel Pivot Table

There are 2 Rows: Dept & Dept Description.  

The top across are drill downs from Year to Qtr

The column values are the Sum of Records Uploaded and Sum of days Saved

 

In Power BI, I can only put Records Uploaded. I've tried drill down by Column and it's not correct.  I'm trying to mimic the Pivot table in Excel that looks like this.

 

 

davehus Member
Member

Re: Matrix with 2 value columns

Hi Cathryn, Have you a sample dataset? What measures have you written so far?
Cathryn Member
Member

Re: Matrix with 2 value columns

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.

 

Capture.JPG

davehus Member
Member

Re: Matrix with 2 value columns

OK, so where is it falling down for you? Are you not able to display all the columns in the grid? Have you an anonymised set of data you could upload?
Cathryn Member
Member

Re: Matrix with 2 value columns

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...Smiley Frustrated Smiley Very Happy

Highlighted
davehus Member
Member

Re: Matrix with 2 value columns

@Cathryn, No problem, glad you got it sorted.. Smiley Happy