Forum Discussion
Advocate IIAdd data from two different data soruces in same visual
Helper VHi AmandaSoborg
Can you be a little more specific. For instance, what is the relationship? Based on date or something.
Because if that is the case, just drag the values from both the datasources into values, and the axis has te be one of the dates.
If you need more help, put some screenshots on the post, makes helping a lot easier
Advocate IIHi miltenburger
I have created a DimDate Table like this; https://www.mssqltips.com/sqlservertip/4857/creating-a-date-dimension-table-in-power-bi/
I then have two other tables, gathers from SalesForce and BW. The BW table is connected to the DimDate table, so that this can show 2016, and 2017 YTD, descreibed as in this post; https://www.mssqltips.com/sqlservertip/4841/calculating-mtd-qtd-ytd-running-and-cumulative-total-in-power-bi/
This I have no problmen with protraying.
Then, I have another table; The SalesForce Table. This tabel is connected with the DimDAte Table, also on date (of first delivery).
So both tables are connected through the same 'Date' columnin the DimDate Table. When I use the DimDate[Date] column as the axis, I do not have a problem when creating two seperate visuals of the Stacked Column Chart. But when I use both the BW and the SalesForce Table, with the DimDate[Date] as axis, it cannot show me the values.
Unfortunally I cannot provide screenshots, as the project is confidential :)
I hope, that you can help me anyway :)
- v-caliao-msft
Microsoft Employee
Do you have relationships created between thoses tables? If the relationships were created success, than you can use Append or Merge queries to add your data into one table, and then you can use the data in that table in your visual.
http://radacad.com/append-vs-merge-in-power-bi-and-power-query
Regards,
Charlie Liao