Triming unwanted data and create another field

[Anonymous]

Hi,

I am new to the forum and started working on Power BI tool, I have excel data set and have 20 fields. I want to create another field by removing some of unwanted data.

Field Name: QtrYr

QtrYr

Q1-2016

Q2-2015

Q4-2015

...

I have used this field in my dashboard as x-axis and when I do sorting I get zig zag, so I wanted to filter the Q1- and Q2- part then I can get another field with Yr only.

Is there any possibilities to achieve this?

Thanks,

[Anonymous · Accepted solution]

Hi @Anonymous,

   if you only want to cut the "Q...-" text in your column. You can:

1) go into the query editor

2) click on "Split column" -> "by delimiter"

3) "select or enter delimiter" -->   "--custom--"   -->  -

4) "Split"  -->  "at the right-most delimiter"

5) ok

And this is the result:

 Let me know if it works.

#I'M Not An Expert#

[Anonymous · Accepted solution]

Hi @Anonymous,

   if you only want to cut the "Q...-" text in your column. You can:

1) go into the query editor

2) click on "Split column" -> "by delimiter"

3) "select or enter delimiter" -->   "--custom--"   -->  -

4) "Split"  -->  "at the right-most delimiter"

5) ok

And this is the result:

 Let me know if it works.

#I'M Not An Expert#

[Anonymous]

Appreciated your support, but if I want keep existsing column and create another fields like Qtr and Yr seperately.

The solution what you have provided is splitting the column.

Any possibioities.

[Anonymous · Accepted solution]

Do all the steps above, but first duplicate the column. Then split the duplicated column as suggested and leave the original alone and you'll have both.

[tjd]

To avoid the zig-zag and get proper order, change (or add a field) to Year-Qtr (2015-Q1, 2015-Q2, etc.).  It will then sort properly on the x-axis.