How can I show a new part of the team in power BI?

[Alan421]

Basically, I am showing data relating to 'x' - let's say it is data relating to how many burgers each member of my team at work has. There are 4 of us. I have data relating to this topic from 4 years ago and I am showing all of this data relating to these 4 people and how many burgers they each have. Now we have 6 members of the team. How can I show this in one visual on Power BI?

[v-yangliu-msft · Accepted solution]

Hi  @Alan421 ,

If your table has the same structure, you can use the function Union() or use Merger Queries in Power Query to form a table so that it will appear in the same Visual.

Union_Table =
UNION(
    'Table','New_Table')

If it doesn't match your expected result, can you express the result you want in the form of a picture, we can better help you.

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[lbendlin]

This is too vague. Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...