Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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.
Please download the attachment to review more details.
Best Regards,
Angelia
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
100 | |
88 | |
69 | |
61 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |