Power BI Builder Matrix Grouping

[amsrivastavaa]

Hi Guys!!

I am newbie to the Power BI Builder and i need to implement grouping in Matrix as shown below

Here ColC is under ColB and ColB under ColA,

I need to group ColA,ColB and ColC, exactly in the same way as it is showing above.

Please help

Thanks

A

[amsrivastavaa]

Hi @v-binbinyu-msft , Thanks for the response.

I am able to create Matrix with Options : Stepped, Subtotal, however, I want to create the same (matrix with Stepped Option) but manually i.e. without using Matrix Wizard

Snapshot of what I am getting it via Wizard is shown.

Please suggest!!

Thanks

A

[v-binbinyu-msft]

Hi @amsrivastavaa ,

Please refer the Gif picture:

Best regards,
Community Support Team_ Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amsrivastavaa]

Hi @v-binbinyu-msft 

The way you have mentioned is not giving Stepped Matrix.

Please suggest!

Thanks

A

[v-binbinyu-msft]

Hi @amsrivastavaa ,

Use the matrix wizard to provide a starting design on which to display data. The preview pane in the wizard helps you to visualize the result of grouping data before you complete the matrix design.

1. On the Arrange fields page, drag Territory from Available fields to Row groups.
2. Drag SalesDate to Row groups and place it below Territory.
3. The order in which fields are listed in Row groups defines the group hierarchy. Steps 1 and 2 organize the values of the fields first by territory, and then by sales date.
4. Drag Subcategory to Column groups.
5. Drag Product to Column groups and place it below Subcategory
6. Drag Sales to Values. 
7. Drag Quantity to Values.
8. Click Next.
9. On the Choose the Layout page, under Options, verify that Show subtotals and grand totals is selected.
10. Verify that Blocked, subtotal below is selected.
11. Verify the option Expand/collapse groups is selected.
12. Click Next.
13. Click Finish.
14. Click Run to preview the report.
15. Expand a subcategory. You can see the report quickly gets quite wide.

For more details, you can read related document: Tutorial: Creating a Matrix Report (Report Builder) - SQL Server Reporting Services (SSRS) | Microso...

Best regards,
Community Support Team_ Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.