Forum Discussion

natfg23's avatar
natfg23
New Member
4 years ago

Compare Scenarios

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:   Ba...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi natfg23 ,

 

It seems that you want to show Values of each Month and each Scenario.

 

Please firstly use "Unpivot" to transform data:

Then create a Stacked Bar Chart or Clustered Bar Chart:

 

Or if it's not your expected output , Please share more details as suggested by Vijay_A_Verma  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

 

 

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

natfg23's avatar
natfg23
New Member
4 years ago

Hi, 

 

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. 

 

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.

  • natfg23's avatar
    natfg23
    New Member
    4 years ago

     This is the graph with only Factory and Scenario Unpivoted