Slicer selection filtering on related column

[worker85]

I have a very simple table with a list of Units in, each unit is a subcategory of a Network (as in the table below). Is it possible to set up a slicer so that a user can select a Unit, then see a filtered bar chart of all units from their Network? 

I realise I could easily accompish this with a Network slicer, but the page has other visuals based on the Unit and I do not want to require multiple slicer selections.

Many thanks for any help.

Unit	Network	value
Unita	Networka	12
Unitb	Networka	32
Unitc	Networka	65
Unitd	Networka	23
Unite	Networkb	57
Unitf	Networkb	21
Unitg	Networkb	43
Unith	Networkc	97
Uniti	Networkc	34

[Sahir_Maharaj]

Hello @worker85,

1. Create a measure that calculates the total value of the Network based on the selected Unit

Network Total = CALCULATE(SUM('Table'[value]), ALL('Table'[Unit]), 'Table'[Network] = SELECTEDVALUE('Table'[Network]))

2. Create a bar chart visual that shows the 'value' column on the Y-axis and the 'Unit' column on the X-axis. Enable Drillthrough for the bar chart by going to the Format pane, selecting the visual, and then turning on the Drillthrough toggle.

3. When you select a specific Unit in the slicer, you can drillthrough to the Network Total measure by right-clicking on the bar chart and selecting "Drillthrough" > "Network Total". This will show a filtered bar chart of all Units in the selected Network, based on the selected Unit.

Let me know if you have any other questions.

[worker85]

Thank you very much for the quick reply.

I can't see a Drillthrough toggle anywehre on the Format pane. There is only "Drill through cross report" and "Drill through Keep all filters".