Control values in one slicer based on selection in other slicer

[ManojG]

Hi,

I have created two tables(Calculated tables using multiple functions to filter/sort the required data). There is one common Column between both the Tables.

I have created two Slicers, one each for both the tables. 

The Charts I designed are filtering data correctly for the slicers. 

The helpI need is that I want to control the values in second Slicer if I have selected a value in first slicer and vice versa. 

e.g. if I select Asia in first Slicer(Region), Second Slicer should show only India, Japan etc.(depends on how countries are mapped to a region) and of course charts should show numbers as per the selection i.e. If I select Asia from first Slicer then only India and Japan will appear in second slicer and if numbers will change if I select India or Japan.

[vanessafvg · Accepted solution]

have you tried to use selectedvalue() and isfiltered()?  

this is a good blog post.   https://powerpivotpro.com/2018/02/using-selectedvalues-capture-power-bi-slicer-selections/

[v-robertq-msft · Accepted solution]

Hi, @ManojG 

According to your description, you want to make the selected value of the first Slicer to affect the value to be selected in the second value, I created some data and make a relationship between the tables to achieve this, you can take a look:

1. I created the data like this:

2. I link the two tables like this(one to many, single filter):

3. Then I created the two Slicers, I can filter the second one using the first one, like this:

And you can get what you want.

You can download my test pbix file here

If this result is not what you want, you can post some sample data(without sensitive data) and your expected result.

How to Get Your Question Answered Quickly 

Best Regards,

Community Support Team _Robert Qin

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

[vanessafvg · Accepted solution]

have you tried to use selectedvalue() and isfiltered()?  

this is a good blog post.   https://powerpivotpro.com/2018/02/using-selectedvalues-capture-power-bi-slicer-selections/