Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Reply
VasTg
Memorable Member
Memorable Member

Set 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

 

SLICER2DATEDATE_KEY
LBDCURRENT20200121
MTDCURRENT20200121
MTDDec-1920191231
MTDNov-1920191130
QTDCURRENT20200121
QTDDec-1920191231
QTDNov-1920191130
YTDCURRENT20200121
YTDDec-1920191231
YTDNov-1920191130
FYTDCURRENT20200121
FYTDDec-1920191231
FYTDNov-19

20191130

 

A relationship is defined based on slicer column.

 

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

Cap11.PNG

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.

 

 

 

 

 

Connect on LinkedIn
1 ACCEPTED SOLUTION
v-yuta-msft
Community Support
Community 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.

View solution in original post

2 REPLIES 2
powerBIuser2937
Frequent Visitor

any news on this topic?

v-yuta-msft
Community Support
Community 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.

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.