Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Karola
Helper I
Helper I

transfer selected data from one table to another (visual interaction between pages)

i looking for a way to transfer data from one table to a table on another tab. 

 

example: 

on tab 1 i have a table with the following items: 

Letter

A

B

C

D

E

F

 

no i selected or filtered so i only have 

Letter

A

B

C

D

 

Is there a way to only take A, B, C and D to another table on tab 2

like: 

tab 2

Letter   measure

A          24

B          50

C          35

D          15

 

i dont want to see all the data in my tab 2.. only the data i have selected/filtered on tab 1

3 REPLIES 3
v-yalanwu-msft
Community Support
Community Support

Hi @Karola ,


According to your description, if the two tables are related, you could directly use the sync slicer, if not, you could add a flag measure,as follows:
1.IF two tables have relationships, you could use sync slicer

v-yalanwu-msft_3-1620350527027.jpegv-yalanwu-msft_4-1620350530094.jpeg

2.IF two tables don’t have relationships ,You could add a flag measure and apply it in filter :

flag = IF(MAX('Table (2)'[Letter]) in ALLSELECTED('Table'[Letter]),1)

v-yalanwu-msft_5-1620350544717.jpeg

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Karola
Helper I
Helper I

@amitchandak Maybe i don't get you or you don't get me but it has nothing to do with the measure. 

let's see if i can make a simpler example

I have 2 tabs (pages) in my power Bi report. 

on both tabs i have a table visual. 

both have the same columns 

cow   milk (kg)

1        30

2        20

3        25

4        35 

5         51

6         60

7         15

etc.

 

now i would like to take a selection of the list to the table visual on tab 2

so i ctrl click on cow 1 and 2 in the table on tab 1 for example and only those cows are visible on the table on tab 2

 

so my result is then on tab 2

cow    milk (kg)

1         30

2         20

 

its like visual interaction but not on the same page. 

is something like that possible.. 

 

amitchandak
Super User
Super User

@Karola , Create a measure like (used your measure in that) and use with letter of table 2

 


measure =
calculate([measure], filter(table2, table2[Letter] in values(table1[Letter])))

 

or you can have count(Table2[letter]) in place of measure, as per need

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.