Forum Discussion

Anonymous

Not applicable

6 years ago

Solved

Relationship column & table name

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)...

amitchandak
6 years ago
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.

Advocate II

6 years ago

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