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