Showing two matrix in one visual for comparison

[Anonymous]

Hello,

I have an actual matrix of values with over 8000 rows and another matrix showing target values. I would like to graph them using one visual:

The first picture is showing my suggested visuals to illustrate the data in 2 matrixes: the left one is the actual data with +8000 rows and the right one is target. the below picture is the matrix for target data. I used stacked column chart since I have 2 matrixes but now wanted to put them in one visual(instead of 2 stacked column visuals that I did). I don't want to make a join but just to show them in one single visual. what is the visual I should use and if I need to modify my data model, how?

[v-piga-msft]

Hi @Anonymous ,

If I understand your requirement correctly that you want to show the data in the two matrix to be in one visual?

If it is, is the data in the two matrix from the different table?

If it is convenient, could you share your data sample as table format and your desired output so that we could help further on it? 

Best Regards,

Cherry

[Anonymous]

Hi @v-piga-msft 

Yes data are in 2 different tables. My problem is to join the tables or develop an staked column chart to show the data. Either of them would suffice.

Please let me know how to do any of the above?

[v-piga-msft]

Hi @Anonymous ,

Sorry for the delay.

For your requirement, I'm afraid that you'd better create the relationship between the two tables firstly, and then create the staked column chart in Report view.

In addition, could you share show your sample data in text-tabular format in addition to (or instead of)  screen captures. That allows people trying to help to readily copy the data and run a quick test, plus it increases the likelihood of your question being answered. Just use 'Copy table' in Power BI and paste it here. Or, ideally, share the pbix (beware of confidential data).

Best  Regards,

Cherry

[Anonymous]

@v-piga-msft, unfortunately there is no wsy to share the data due to confidentiality. Actually the visualisation of data for both actual and plan can be best shown in stacked column chart! As you can see I in each column I have to illustrate different values which stack up in any of the work stations and they are not constant, as you see different columns show different number of stacked values. The Actual data matrix is +9000 rows of data which filtered down to + 250 rows before moving to the stacked chart. The Actual matrix shape is identical to the Plan data matrix as shown in the following screenshot. My business STEs like to see both Actual and Plan in single chart view to be able to have better undersding. Please help me if it's possible to show a clean stacked column bar chart with 2 different type of data set? I need a good and correct answer asap.

Thanks again