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 Team,
I'm looking for a solution to the below issue, please help..
Both slicers X1, X2 are based on the same column/field..but my requirement is when I pick a person from first slicer..that name should disappear in second slicer...any idea on how to implement the logic here..
Thanks.
Solved! Go to Solution.
Hi , @kkalyanrr
I didn't find the way to realize it in the slice. The reason is as follows:
(1)Measures cannot be placed in slicers.
(2)Tables don't have a filtering context, and we can't generate a table dynamically
We ca realize it in the table , If this helps you, you can refer to it:
(1)This is my test data :
(2)We can click "New Table" to create another table:
Table 2 = VALUES('Table'[test])
(3)We can create a measure :
Measure = var _slice= VALUES('Table'[test])
return
IF( SELECTEDVALUE('Table 2'[test]) in _slice ,0,1)
(4)We can put the 'Table'[test] in the slice and the 'Table2'[test] in the table, then we need to configure the "Filter on this visual" in the table, like this:
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi , @kkalyanrr
I didn't find the way to realize it in the slice. The reason is as follows:
(1)Measures cannot be placed in slicers.
(2)Tables don't have a filtering context, and we can't generate a table dynamically
We ca realize it in the table , If this helps you, you can refer to it:
(1)This is my test data :
(2)We can click "New Table" to create another table:
Table 2 = VALUES('Table'[test])
(3)We can create a measure :
Measure = var _slice= VALUES('Table'[test])
return
IF( SELECTEDVALUE('Table 2'[test]) in _slice ,0,1)
(4)We can put the 'Table'[test] in the slice and the 'Table2'[test] in the table, then we need to configure the "Filter on this visual" in the table, like this:
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
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 |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |