Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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.
Solved! Go to 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.
any news on this topic?
@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.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
111 | |
96 | |
90 | |
79 | |
67 |
User | Count |
---|---|
153 | |
125 | |
114 | |
111 | |
95 |