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.
Hello,
I have a table of site names and site types. If a user selects one of the site names in a slicer, how I can show all other site names that have the same site type (based on the slicer selection)?
I.e.
Site_Name Site_Type
Site A 1
Site B 1
Site C 2
Site D 3
Site E 1
User selects 'Site A' and a table populates with 'Site A', 'Site B', and 'Site E'
Thanks!
Solved! Go to Solution.
Hi @Gutenvirt,
In this scenario, you should replicate the original table. As a result, there are two tables (In my test, test1 and test2) containing same columns, [Site Name] and [Site Type].
Create a measure like below
Site Type measure = CALCULATE ( LASTNONBLANK ( test1[Site Type], 1 ), FILTER ( 'test1', 'test1'[Site Type] = MAX ( test2[Site Type] ) ) )
Add 'test2'[Site Name] into slicer and add 'test1'[Site Name]and measure [Site Type measure] into table visual.
Best regards,
Yuliana Gu
Hi @Gutenvirt,
In this scenario, you should replicate the original table. As a result, there are two tables (In my test, test1 and test2) containing same columns, [Site Name] and [Site Type].
Create a measure like below
Site Type measure = CALCULATE ( LASTNONBLANK ( test1[Site Type], 1 ), FILTER ( 'test1', 'test1'[Site Type] = MAX ( test2[Site Type] ) ) )
Add 'test2'[Site Name] into slicer and add 'test1'[Site Name]and measure [Site Type measure] into table visual.
Best regards,
Yuliana Gu
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 |
---|---|
110 | |
97 | |
78 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |