Forum Discussion

bostewart_key7's avatar
bostewart_key7
New Member
8 years ago

Change Matrix Grouping With Slicer

I'm trying to allow my users to dynamically choose a group by option for the matrix control.   As an example I have sales data that is categorized by 2 different attributes, Location and Reporting Category.    These 2 attributes are not related so placing them in a hierarchy does not produce the desired result.  Ideally I'd like the Rows grouping in the matrix to be able to update based on a value selected from a slicer, where the slicer has 2 options (Location and Reporting Category).    So the data might look something like:

 

When grouped by Location (selected in the slicer):

Location    Amount

Loc 1         100.00

Loc 2         150.00

Total          250.0

 

When grouped by Reporting Category (selected in the slicer):

Reporting Category     Amount

Cat A                            75.00

Cat B                            125.00

Cat C                            50.00

Total                             250.00

 

I am stuck on how best to accomplish this in PowerBI.

1 Reply