Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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.
Hi guys.
Thanks for all your help! With unpivot 80% of the problem could be solved. Thank you!
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
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |