Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi @ybicalways
Has your problem been solved ? If it has been solved , please attach your reply and accept it as the solution to help the other members find it more quickly . If it has not been solved , please provide your pbix file and the result you want to help us to deal with the problem easier .
Best Regard
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@ybicalways , Not very clear, You need share a data example.
1. A slicer can not initialize another slicer.
2. We can reduce value of another slicer
To do that we can use a common fact or A measure to pass the value.
Assume Dim1 and Dim2 has common fact. Then you can use countrows(fact) not blank in the slicer's visual level filter
Assume Table 1 and Table 2 are independent tables with common column A
then for Table a
Create measure
countrows(Filter(Table1, Table1[A] in values(Table2[A] ) ) , Again use this in the slicer of table1 a s visual level filter and check for not blank
if you want to copy values across
refer 4 ways to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8
User | Count |
---|---|
41 | |
27 | |
23 | |
18 | |
15 |
User | Count |
---|---|
54 | |
35 | |
19 | |
18 | |
15 |