Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I created two reports A and B, both datesource is sql database using import mode, report A use data from table1 and report B use data from table2, there is no relationship between table1 and table2 in data model, and there is a silicer with the same name in these two reports, and slicer data is from table1 and table2, and have same column name, is there a method to achieve that when slicer in A choose a value "South" and then click the button with bookmark of page B to switch to B, then B slicer choose "South" automatically?
Solved! Go to Solution.
@Anonymous , Better to create a common table and join with both tables for that column and keep the slicer in sync across pages
Region= distinct(union(distinct(Table1[Region]),distinct(Table2[Region])))
@Anonymous , Better to create a common table and join with both tables for that column and keep the slicer in sync across pages
Region= distinct(union(distinct(Table1[Region]),distinct(Table2[Region])))
User | Count |
---|---|
127 | |
108 | |
99 | |
63 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |