Forum Discussion

hgzelaya's avatar
hgzelaya
Helper I
8 years ago
Solved

Multiple Variables on X Axis

Hi,   im having trouble representing this same graph on power BI.   Thing is it won't let me because power BI is only able to use one variable (can't use many as shown above).   here's wh...
  • parry2k's avatar
    parry2k
    8 years ago

    basically you need to unpivot your table and follow these steps

     

    - goto edit query

    - right click type field of your table

    - select unpivot other columns

    - change attribute column header to KWH

     

    - close and apply

     

    choose clustered column chart visual

     

    - put kwh on axis

    - put type on legend

    - put value on value

     

     

parry2k's avatar
parry2k
Super User
8 years ago

I believe there is need to change the data model which can be done in power itself. if you can share sample data in a sheet thru google drive or something like that

  • parry2k's avatar
    parry2k
    Super User
    8 years ago

    this is the ouput you are looking for, correcT?

    • hgzelaya's avatar
      hgzelaya
      Helper I
      8 years ago

      yes it is!

      • parry2k's avatar
        parry2k
        Super User
        8 years ago

        basically you need to unpivot your table and follow these steps

         

        - goto edit query

        - right click type field of your table

        - select unpivot other columns

        - change attribute column header to KWH

         

        - close and apply

         

        choose clustered column chart visual

         

        - put kwh on axis

        - put type on legend

        - put value on value