Set slicer value based on another slicer

[VasTg]

Hello,

I am trying to set a default value to second slicer when the value selected in first slicer is "LBD".

I have two tables

Table1

SLICER1

LBD

MTD

QTD

YTD

FYTD

Table2

SLICER2	DATE	DATE_KEY
LBD	CURRENT	20200121
MTD	CURRENT	20200121
MTD	Dec-19	20191231
MTD	Nov-19	20191130
QTD	CURRENT	20200121
QTD	Dec-19	20191231
QTD	Nov-19	20191130
YTD	CURRENT	20200121
YTD	Dec-19	20191231
YTD	Nov-19	20191130
FYTD	CURRENT	20200121
FYTD	Dec-19	20191231
FYTD	Nov-19	20191130

A relationship is defined based on slicer column.

I have Table1[slicer 1] and table2[date] columns as two slicers.  

Expected Output:

Whenever I choose LBD('T-1' as per image) in slicer 1, I want the slicer 2 to default to "Current".

But if I have "Nov 2019" selected for YTD, I still want the "Nov 2019" selection for MTD or QTD or FYTD.

Appreciate your help.

[powerBIuser2937]

any news on this topic?

[v-yuta-msft · Accepted solution]

@VasTg ,

I'm afraid this can't be achieved in power bi. The slicer can only filter other visuals, but can not control the selections in other slicers.

Community Support Team _ Jimmy Tao

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