Quartlery Data

[Spooner]

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

[Eric_Zhang]

@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.

[mikes2nd]

lets see what you want. Like this?

[Spooner]

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]

Look into "transforming the query".

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