Forum Discussion
Memorable MemberSet slicer value based on another slicer
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.
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.
2 Replies
v-yuta-msftCommunity Support
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.
