cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Karola
Frequent Visitor

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
Frequent Visitor

@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 IV
Super User IV

@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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Get Ready for Power BI Dev Camp

Power BI Dev Camp - June 24th

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors