Compare Scenarios

Question

So I have this table and I want to compare column Scenarios (where there are Act19, Act20, Act21, FC1, and so on) and convert columns (January, Feb,March, etc) so I can visualize a graph with:

Bar with Value of January for Act 19, Act 20, Act 21...

Bar with Value of February for Act 19, Act 20, Act 21...

Factory	Scenario	Currency	Labour Class	January	Feb	March
TLP	ACT 19	LC	Direct	195990	207890	299566
ABN	ACT 19	LC	Direct	456000	213405	983740
DEL	ACT 19	LC	Direct	958674	983045	890475
TLP	ACT 20	LC	Indirect	234958	192304	579384
TLP	ACT 20	Const.	Indirect	1568	2394	2398
ABN	ACT 20	Const.	Indirect	3456	2457	2458
DEL	ACT 20	Const.	Indirect	2576	8765	2066

vijay_a_verma · Answer

I think some more explanation is needed. Are you looking to get a Sum of Jan, Feb, Mar for ACT 19, ACT 20 etc....If you can explain your requirements clearly, then that would be great.

anonymous · Answer

Hi&nbsp;natfg23&nbsp;,
&nbsp;
It seems that you want to show Values of each Month and each Scenario.
&nbsp;
Please firstly use "Unpivot" to transform data:

Then create a Stacked Bar Chart or Clustered Bar Chart:

&nbsp;
Or if it's not your expected output , Please share more details as suggested by&nbsp;Vijay_A_Verma&nbsp; to help us clarify your scenario.
Refer to:
 How to Get Your Question Answered Quickly - Microsoft Power BI Community 
 How to provide sample data in the Power BI Forum - Microsoft Power BI Community 
&nbsp;
&nbsp;
Best Regards,Eyelyn QinIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

natfg23 · Answer

Hi,&nbsp;&nbsp;This helped but it only lets me unpivot 2 columns. So when I unpivot Factory and Scenario, Scenario Dissapears and it shows me the total of all scenarios and I need a bar for ACT19, ACT20, ACT21 and son on.&nbsp;&nbsp;Let me show you my database.And I want to graph on X the Columns 1, 2, 3, 4,.... (months) and Y axis for Each factory, a bar for each scenario each Class.