Forum Discussion
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)
| 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
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.
4 Replies
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.
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.
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
