How to split data columns in Power BI using Power Query Editor

Published 7 days ago • 2 min read

​

How to ...

Hi Reader,
​
This week's post is all about splitting data columns using Power Query Editor. Sometimes your data source has information that would be more useful in 2 (or more) columns all smushed together into 1 column...
​
While it's best to fix this in your actual data source, sometimes you don't have direct access to it, so you need to do it in Power BI itself, using Power Query Editor.
​
It's nice and easy to do, if you need to!
​
​How to split data columns in Power BI using Power Query Editor​

​

Not loving How To Use Power BI in your inbox anymore? Unsubscribe here.

(because you should only get these emails if you love them and find them useful!)

​

Recently on How To Use Power BI:

​Pie Chart Post Series​

How to (and NOT to) make, format and label Pie Charts

​How to custom color labels on a Pie Chart​

There's a trick to get your pie piece and label colors to match...

​DAX: FORMAT​

Your introduction to the FORMAT function in DAX... format things in lots of different ways for different purposes.

Connect with me on LinkedIn.

I post a few times a week... and I try and make it fun. :)

​

Power BI Crash Course in Kansas City!

​

This November, I'm headed back to the American Evaluation Association annual conference to teach a bunch of lovely evaluators how to get started with Power BI.
​
You (and your evaluator friends) can ALSO sign up for notifications on a little mini-site I've made for the conference...
it's at https://traversdata.com/aea2025/​

​

Check out our How-To Subject collections

​Bar Charts​

Making, formatting, fixing, even adding benchmark lines to bar charts.

​DAX​

Making, formatting, fixing, even adding benchmark lines to bar charts.

​Hot (& Fresh) Tips!​

Making, formatting, fixing, even adding benchmark lines to bar charts.

​

​

More from Joe (me)!

​You can learn from me in a workshop​

I run friendly and informative Beginner and Advanced Power BI workshops. Get started (or level up if you already know the basics) so you can start reporting insights from your data ASAP! Hit the reply button on this email and let's chat.

​You can pick my Power BI Brain​

After 7+ years of using Power BI daily, I've come across (and sworn at) a LOT of error messages, things that don't make sense, and other challenges. You don't have to go through it all too... you can get me to help you through the challenges. Don't spend hours/days/weeks being frustrated... I've already gone through that FOR you. Talk to me. I can help.

​

Take care everyone,
​
Joe.
​

​

​TraversData.com | LinkedIn | Instagram ​

​



​

​

Subscribe to Joe Travers