Forum Discussion

Spooner's avatar
Spooner
New Member
10 years ago

Quartlery Data

Hello everyone,

 


I am a brand new user of PowerBI and have been experimenting wtih the platform for the last few days, so please excuse me if this question is rudimentary.   I have spent considerable time watching youtube tutorials and reading this forum, but have not seen any clear way to create a trend line for multiple initiatives with the quarters on the X axis and values on the Y axis with data from an excel spreadsheet (excel data example below).

When I try to create this visual, I either end up with the Inititaves on the X axis with each quarter showing as a single value, or with a single quarter on the X axis and the rest of the data plotting against that quarter.  I realize that many of the tutorials say to assign a single date column to an Axis (and I have used this correctly on other projects) but is there any way to have multiple quarters on the X axis with data for each Initiative without reformatting my entire excel spreadsheet (I am trying to avoid this as it is many thousands of rows)?

 

Thanks,
Spooner

 

 

4 Replies

    • Spooner's avatar
      Spooner
      New Member
      10 years ago

      Thanks Mike, but I actually want the inverse of that where the quarters are on the X axis and the various initiatives are the lines.  My issue is I am unable to get the quarters on the X axis!

      • mikes2nd's avatar
        mikes2nd
        Helper I
        10 years ago

        Look into "transforming the query".

         

        Click on "edit query" go into transform and transpose it.  This should work.

         

         

  • Eric_Zhang's avatar
    Eric_Zhang
    Microsoft Employee
    10 years ago

    Spooner

    To apply the quarters to X axis, you can follow below steps.

    1. Click edit query
    2. Select the 6 columns and unpivot
    3. Close the edit queries window and apply the change. In the powerbi desktop window, create a new column.
      Quarter = CONCATENATE( RIGHT('table'[Attribute],4), LEFT('table'[Attribute],2))
    4. Done

    If you have any question, feel free to let me know.