Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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,
Solved! Go to 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#
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.
Proud to be a Super User!
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#
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.
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.
Proud to be a Super User!
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |