Forum Discussion

tomgramling's avatar
tomgramling
Regular Visitor
6 years ago
Solved

Dynamic grouping based on slider selections

Here's what I'm trying to do and caveat, I'm super new to power bi so hopefully this is really easy and I just don't know what I'm doing. 

 

I want to have a number of slicers with the same selections in each. These selections would impact the grouping of my matrix.

 

So for instance I have this data set. I would have 3 slicers and each would have the values None, State, County and City.

 

StateCountyCity Poplation
GeorgiaDeKalbTucker100
IllinoisDeKalb Malta200
GeorgiaFultonAtlanta300
FloridaManateeBradenton250
GeorgiaDekalbDoraville50

 

If I make these slicer selections this is what I would expect the resulting matrix to look like.

 

First Slicer - state, Second slicer - none, Third slicer - none

Resulting matrix -

Georgia 450
Illinois 200
Florida 250

 

First Slicer - state, second - county, third - none

Resulting matrix -

Georgia, Dekalb 150
Georgia, Fulton 300
Illinois, Dekalb 200
Florida, Manatee 250

 

first slicer - county, second - none, third none

Resulting matrix -

Dekalb 350
Fulton 200
Manatee 250

 

And so on for every possible combination of selections.

 

So what I think I'm asking is is there a way to dynamically group and regroup a matrix based on the selections made in slicers?

 

Thanks, 

Tom

 

2 Replies