Forum Discussion
Showing two matrix in one visual for comparison
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?
Resident RockstarHi 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
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