Automatically set dependent slicer depending on user selection of another slicer

Hi  Anonymous ,

I created some data:

Sorry, only ALL appears in the first line of the Dropdown slicer. This may be a power bi design problem.

You can submit an idea for it at https://ideas.powerbi.com/forums and wait for users with the same needs as you to vote for you to help make it happen as soon as possible.

Or do you consider the following options

1. You can turn it into a List form, which will display the Region information directly:

Create calculated table.

Table 2 =
DISTINCT('Table'[Department])

Create measure.

Flag =
var _select=
SELECTEDVALUE('Table 2'[Department])
var _selectcolumn=SELECTCOLUMNS(FILTER(ALL('Table'),'Table'[Region]=MAX('Table'[Region])),"1",[Department])
return
IF(
    _select in _selectcolumn,1,0)

Place [Flag]in Filters, set is=1, apply filter.

Result:

2. Or set a custom title, after the slicer is selected, the corresponding Region will be displayed on the title.

Create measure：

Measure =
var _select=
SELECTEDVALUE('Table 2'[Department])
return
"Region :"&" "&
MAXX(FILTER(ALL('Table'),_select ='Table'[Department]),[Region])

Format  --  Slicer header – fx.

Result：

If you need pbix, please click here.

Test01.pbix

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly