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