Filtering a chart to show all rows with a cross-filtered value

[aawve]

Hello,

I have data in the following structure:

Group	SubGroup	SubGroupValue
Group1	Sub1	3
Group1	Sub2	6
Group1	Sub3	6
Group2	Sub4	4
Group2	Sub5	1
Group2	Sub6	8
Group2	Sub7	2
Group3	Sub8	3
Group3	Sub9	7
Group3	Sub10	8

The end user of the Power BI report has slicers for both "Group" and "SubGroup", but they will be primary interested in filtering down to a single "SubGroup" value at a time.

I want to make a column chart that shows one "SubGroupValue" column for each "SubGroup" within the selected value of "Group". I mocked up some examples in Excel below. The top chart ("Have") reflects the column chart before an end user filters to a single "SubGroup" value. The bottom chart ("Want") reflects the desired column chart after an end user filters to a single "SubGroup" value (i.e., "Sub2").

Please provide ideas on efficient ways to accomplish this feature. Thank you.

[v-henryk-mstf]

Hi @aawve ,

Whether the advice given by @lbendlin  has solved your confusion, if the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly. If not, please point it out.

Looking forward to your feedback.

Best Regards,
Henry

[aawve]

Henry:

I haven't been able to replicate the solution yet. In particular, I can't seem to set up the initial visualization, such that the up arrow isn't grayed out.

Ibendlin:

What visualization are you using initially? And in which spots did you put the fields?

Thank you

[lbendlin · Accepted solution]

see pbix attached. Each page shows the next step

[lbendlin]

From here

click the up arrow

then right click on the first bar and click "Drilldown"

To get to where you wanted to take it