Slicer base on column base on slicer

[vazmor]

How can you do the following ?, I have a table with 4 columns "Table2" and I want to have a slicer of the table3 with the countries and when selecting "UK", I load in a slicer the data of the UK column of the Table2

https://drive.google.com/file/d/0Bz_yJn-MHA2oNjBHRzBnbUVSZk0/edit

[v-huizhn-msft]

Hi @vazmor,

If my understanding is right, you want to display the UK column's value when you select "UK" in slicer, right? If it is, please create a measure using the formula below.

different country's value = SWITCH(SELECTEDVALUE(Table3[Country]),
	"UK", MAX(Table2[UK]),
	"Chinese",MAX(Table2[Chinese]),
	"US",MAX(Table2[US]))

You will get the expected result as follows.

Select ChineseSelect UK
Please download the attachment to review more details.

Best Regards,
Angelia

[vazmor]

hello, what I need is that the country slicer generates another slicer with the data of the country column, as well as in the image and that in addition that slicer serves me to filter the table.

[v-huizhn-msft]

Hi @vazmor,

I got it now. Until now, we can't achieve your requirement in Power Bi desktop. You can create an idea here.

Best Regards,
Angelia