Dynamic Visuals/ Company

[Anonymous]

I am newbie, so I apologize in advance. I have 6 tables that all have the same catagories of data for different companies (See table below A-F). At the top of my dashbaord, I would like to be able to select a specific company A-F and for all my visuals to update to just that companies data. I also want to have a cumulative for all of those companies. 

My data:

My data

Please help. I have been googling and watching so many videos and have not figured it out yet.

[parry2k · Accepted solution]

@Anonymous here is what I will do:

- add company column in each table (in power query)

- append all tables together (in power query)

now you will have one table with all the data and it will contain company code/name in it. Now you can do all your visualization from this table and filter on company

[v-juanli-msft · Accepted solution]

Hi @Anonymous 

parry2k pointed the right direction.

If you are a newbie of Power BI, there are some useful documents you could refer to:

Append in Power BI

Create relationship

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[parry2k · Accepted solution]

@Anonymous here is what I will do:

- add company column in each table (in power query)

- append all tables together (in power query)

now you will have one table with all the data and it will contain company code/name in it. Now you can do all your visualization from this table and filter on company