WiseOwl Training - Established 1992 Wise Owl Training

Established May 1992
30 years in business
Wise Owl Training
30 years in business
See 482 reviews for our classroom and online training
New features introduced in the July 2019 update of Power BI
Part six of a seven-part series of blogs

There are big changes to conditional formatting this month (you can display icons, and use percent-based thresholds), but the biggest change of all is the release - finally - of the new filter pane.

  1. Changes introduced in the July 2019 Power BI update
  2. The new fllter pane
  3. Adding icons into the table and matrix visuals
  4. Conditional formatting using percentages
  5. Aggregation tables
  6. Little updates and changes (this blog)
  7. Features waiting in preview

For a cumulative list of all of the updates to Power BI Desktop in the last few years see this blog, or have a look at the Power BI courses that we run.

Posted by Sam Lowrie on 02 August 2019

You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.

Little updates and changes

Not all updates can be as profound as the filter pane, so here are some other little releases and tweaks.

Data colours are now compatible with play axis

Now it is possible to change the data colour settings on a scatter chart  when using the play axis feature:

Power BI Scatter chart

This also includes adding the elusive conditional formatting option (hidden under the 3 dots) to a scatter chart.


Now your chart can have custom colours for each of the values in the Details field:

Power BI Scatter Chart

Since there is a Color by category option which changes them all, I never noticed that this didn't work!

Row level security (RLS) works with Aggregation

This is a small bug fix which previously meant RLS couldn't be implemented on a dataset including an aggregate table:

Power BI RLS

Now you can have your big data and your RLS too.


Split column by character position

This new feature can be found in Query Editor under Split columns along with options such as By delimiter and By number of characters:

Power BI Split By Position

Split by position is perfect when the structure of the output is always the same.

Here a 4 digit year is followed by a 4 digit ID and a variable length code. Since the first two splits occur at a fixed position 4 and 8 we can use Split by position:

Power BI

These are some of my favourite options along with Digit to Non-Digit and upper case to lower case.

Once selected a pop-up will prompt for a comma-separated list of the character positions to split at:

Power BI Split Column

This will split the existing column into 3 columns: characters 0 to 3, 4 to 7 and 8 +.

It is important to include the first value or the columns would return characters 4 to 7 and 8+ only:

Power BI Split Columns

Now the data is separated into Year, TranID and Sale Code.

Another useful addition to the Query Editor arsenal!

This blog has 0 threads Add post