Relationship column & table name

[Anonymous]

Hi all, 

I am working on a Power Bi dashboard and I would like to add a slicer based on values from the table names. My data sets looks something like this:

Table 1 contains(company 1/Donald)

Date	Sales	Sales last year	#Inventory	Company name
1-1-2020	1,234	4,321	2	Donald
2-1-2020	2,345	3,219	4	Donald
3-1-2020	3,456	2,198	8	Donald
4-1-2020	4,567	1,987	16	Donald

Table 2 contains(company 2/Kwik)

Date	Sales	Sales last year	#Inventory	Company name
1-1-2020	5,678	9,876	32	Kwik
2-1-2020	6,789	8,765	64	Kwik
3-1-2020	7,891	7,654	128	kwik
4-1-2020	8,912	6,543	256	Kwik

Currently I make a relationship between the "date" colums, by doing so I can make charts with sales, sales last year and inventory levels. Every table contains data derived from a single company (75+). However, I would like to build the following:

Adding slicers based on company name and attribute to be shown. I tried to add an additional 'attribute' and 'company list' table. However, I don't succeed to make a correct relationship between all tables. Thank you in advance. 

Haas

[Anonymous]

Hi guys. 

Thanks for all your help! With unpivot 80% of the problem could be solved. Thank you!

[lbeneyze]

Good evening,

Do you havea data model you can share?

Based on the information you gave:

  - Append your 2 datasets in powerquery to get one table as proposed by amichandak

  - Duplicate the query and remove duplicates in power query to create a company name dimension:

https://www.youtube.com/watch?v=vjBprojOCzU

  - Create your relationship and your slicer.

PS: Maybe good to check this post on how to get your question answered quickly 

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Did I answer your question, please mark my post as a solution

If you liked my solution, please give it a thumbs up.

Thank you and keep up the good job!

Kind regards,

Lohic Beneyzet

[Greg_Deckler]

Create a central Date table and use this to build relationships between your other two tables

"Table 1" *--<>--1 "Date" 1--<>--* "Table 2"

Use Date table as the axis of your chart.

[amitchandak · Accepted solution]

You can append these table and do analysis

https://radacad.com/append-vs-merge-in-power-bi-and-power-query

If required you can create company and date dimension.