Forum Discussion
Matrix visualization - to combine 2 datasets
Hello eveyrone
I am really new to the power Power BI - so I would be very thankful if you can advice on what is the optimal way to combine 2 datasets in 1 matrix visualisation.
So my datasets are 2 separate queries / excel files:
• Actual (which is a detailed extract of transaction which is aggregated by the cost types) and
• Budget(which is not detailed at all);
I need to combine actual + planned values to acheive full year forecast
Let say last ended month is March. In the matrix I need to show 3 months of Actual + 9 months, like this (the third table is the
desired oucome)
I loaded my datasets, created all of the necessery connections, etc. the question for me now is how to create this visualisation
3 Replies
- IdrissshatilaSuper User
Hello,
If the two datasets have the same columns, you could make them as a one dataset and thus you can visualise them in one matrix.
to combine your two datasets you should use Append function, Check this link for instructions https://learn.microsoft.com/en-us/power-query/append-queries
If I answered your question, please mark my post as solution so it would appeare to others, Appreciate your Kudos👍
- BI-terRegular Visitor
Hello
Many thanks for you reply
I was thking about DAX kind-of options as it is expectrd to be interactive in some ways
- Ashish_MathurSuper User
Hi,
Share the download link of your PBI file.