Forum Discussion

Ramzey's avatar
Ramzey
New Member
2 years ago

Two sources in the same visual

Hi all,

i haven't found exactly the same problem in this forum thus i'm creating new message. 
[Background] 
I have two separate sources of data  (source1 is direct connection from everyangle, source2 is excel) 

Both sources have the same level of information, e.g. average age of people within a City 
Each source of data is having different cities, e.g. source1 shows major cities in Germany, source2 shows cities in France 

 

[Dashboard]
In dashboard i have a visual - which is a table - that shows a list of cities from source1(Germany), 
Cities are sorted descending per avg age of people in that city 

[Questions]

Can I add into the same visual - the same table - cities from source2(France) 
So the descending sorting will also consider french cities as they would be in the same table 
Each month I want to refresh both sources to see actual situation 

Kind regards

 

2 Replies

  • Hi Ramzey 

     

    You could merge the 2 tables in Power Query into a single table. Then create your visual off the single table?