Forum Discussion
Advocate IIAdd data from two different data soruces in same visual
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 :)
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