A summary of the new features in the October 2018 update of Power BI Desktop
Part three of an eight-part series of blogs

Not an earth-shaking update, but lots of nice new features nonetheless to make your life easier, including a better DAX editor, the ability to search for text when filtering a visual and a clever new connector which guesses what you want to import from a website.

  1. Changes introduced in the October 2018 Power BI update
  2. Changes to the DAX editor
  3. Filters are now searchable (this blog)
  4. Explaining why an increase or decrease has happened
  5. Controlling exporting of data
  6. The Web by Example connector
  7. Other changes in the October 2018 update
  8. Features awaiting in preview as of October 2018

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

Posted by Andy Brown on 19 October 2018

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.

Filters are now searchable

This is a simple change, but a welcome one.  Suppose that you're showing sales by shopping centre and town, but you want to apply a filter to the table to show only Arndale Centre sales:

Sales by centre

To reflect your love of Arndale centres, you want to show only these in your table.

You can now type text into the search box for a filter (you've been able to do this for some time for a slicer):

Searching for text

Here we're looking at all the shopping centres whose names contains Ar.

 

You still have to tick items once the search has done its stuff:

Ticking Arndale centres

There's also an odd space - not quite sure if this is meant to be there.

 

The result - exclusively Arndale!

Table showing Arndale centres

No more painstakingly scrolling down a long list of values to find the ones containing a particular string of text ...

 

Every little helps! 

This blog has 0 threads Add post