Forum Discussion
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
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:
7 Replies
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,
LydiaThis 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.
- Hi Cathryn, Have you a sample dataset? What measures have you written so far?
