cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
nmhung49 Frequent Visitor
Frequent Visitor

Report a Table like Excel Pivot Table

In Power BI, I want to create a report table same pivot table in Excel

 

 

See the picture

 Table.JPG

 

How to be like that, with the format same pivot table in excel

 

Seet Attach file

Example.pbix

Example.xlsx

 

Thank you

1 ACCEPTED SOLUTION

Accepted Solutions
rocky09 Senior Member
Senior Member

Re: Report a Table like Excel Pivot Table

Hey @nmhung49

 

I tried and almost got as yours.

 

Steps Below:

1. I have used Matrix Table.

2. Arranged data as like in the First Image.

3. make sure to OFF Stepped Layout from Visual Formats.

4. Play with Values/subtotals etc..

1.PNG

 

2.PNG

 

 

 

1 REPLY 1
rocky09 Senior Member
Senior Member

Re: Report a Table like Excel Pivot Table

Hey @nmhung49

 

I tried and almost got as yours.

 

Steps Below:

1. I have used Matrix Table.

2. Arranged data as like in the First Image.

3. make sure to OFF Stepped Layout from Visual Formats.

4. Play with Values/subtotals etc..

1.PNG

 

2.PNG