Forum Discussion
Triming unwanted data and create another field
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,
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#
4 Replies
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#
- tjd
Impactful Individual
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.
