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 datase...
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👍
Hello
Many thanks for you reply
I was thking about DAX kind-of options as it is expectrd to be interactive in some ways
