Forum Discussion

vazmor's avatar
vazmor
Icon for Helper II rankHelper II
9 years ago

Slicer base on column base on slicer

  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 c...
Need Help
v-huizhn-msft's avatar
v-huizhn-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

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's avatar
    vazmor
    Icon for Helper II rankHelper II
    9 years ago

    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's avatar
      v-huizhn-msft
      Icon for Microsoft Employee rankMicrosoft Employee
      9 years ago

      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