Power BI Blog: Conference Planning Part 2
4 November 2021
Welcome back to this week’s edition of the Power BI blog series. This week, we finish reorganising some data from a table with a single column and create some visualisations.
Last time, we started with a Table visualisation showing the salespeople that we have optimistically allocated to our upcoming conferences in a variety of UK cities.
![](http://sumproduct-4634.kxcdn.com/img/containers/main/blog-pictures/2021/pbi/197/image1.png/e774d10cbbb9450fc45efbe51abdf434.jpg)
We accessed the Power Query Editor from the ‘Transform data’ option and we transformed our data until we had a column for salespeople and a Location column.
![](http://sumproduct-4634.kxcdn.com/img/containers/main/blog-pictures/2021/pbi/197/image2.png/f32e5a15e2cf9c3e4d2d058458ce054d.jpg)
Next, we can re-order the columns by clicking and dragging, and then filter Column1 to remove anything than begins with ‘Location:’. This is available from the ‘Text Filters’ dropdown:
![](http://sumproduct-4634.kxcdn.com/img/containers/main/blog-pictures/2021/pbi/197/image3.png/f1140ff857fc3b6f5f97a6a24f4a6fc7.jpg)
We specify the string to look for:
![](http://sumproduct-4634.kxcdn.com/img/containers/main/blog-pictures/2021/pbi/197/image4.png/72aa864d2854c6fefb1083fba0ab5792.jpg)
This gives us a list of locations and names. We no longer need the ‘Location:’ label so we can right-click and ‘Replace Values…’.
![](http://sumproduct-4634.kxcdn.com/img/containers/main/blog-pictures/2021/pbi/197/image5.png/36776d1da4d05b45bb5a5d09375f407c.jpg)
We can then remove ‘Location:’ from this column.
![](http://sumproduct-4634.kxcdn.com/img/containers/main/blog-pictures/2021/pbi/197/image6.png/23912d3b1671861e02bebcd5183f1607.jpg)
We may also rename Column1 to Salesperson, and the table is then ready to be loaded to Power BI Desktop.
![](http://sumproduct-4634.kxcdn.com/img/containers/main/blog-pictures/2021/pbi/197/image7.png/6f49c288a0d88a66b427eaf4ece923d6.jpg)
We drag the new columns to the table and create a simple chart with Location as the Axis and a count of Salesperson in the ‘Data Series’.
![](http://sumproduct-4634.kxcdn.com/img/containers/main/blog-pictures/2021/pbi/197/image8.png/b9ee28d90e6b5bc92ea4aeafdad51628.jpg)
Finally, if the original data source changes as more salespeople have been added, we may refresh to see the changes on Power BI Desktop:
![](http://sumproduct-4634.kxcdn.com/img/containers/main/blog-pictures/2021/pbi/197/image9.png/0485ccbc83bdeec1d741bad442a1ea5f.jpg)
The changes are through: looks like Cardiff and Dublin will have fun!
![](http://sumproduct-4634.kxcdn.com/img/containers/main/blog-pictures/2021/pbi/197/image10.png/daf8c4f0259ce428269c0d3d4badd32b.jpg)
(Always good to see my jokes are appreciated – Ed.)
Check back next week for more Power BI tips and tricks!