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

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

     

     

    • hgzelaya's avatar
      hgzelaya
      Helper I
      8 years ago

      Thank you very much i've been trying to do this long time ago with past visuals. Worked like a charm!

       

       

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi parry2k ,

       

      When i finished ''- close and apply'' and then go back to chart, it shows error code below.

      May i know how to fix it?

       

       

       

      Re: Data refresh: OLE DB or ODBC error: Exception from HRESULT: 0x80040E1D