COVID-19: Choose between our familiar (but now socially distanced) classroom training courses and our excellent new live online courses.
The March 2020 update to Power BI desktop is a full one, as this blog shows!
Part six of a eleven-part series of blogs

New goodies in this month's update include the roll-out (sort of) of the new ribbon, new actions for buttons, multi-column sorting and a second axis for line charts.

  1. The March 2020 Power BI Desktop Update
  2. The new ribbon is live (sort of)
  3. Page navigation buttons
  4. Drill-through navigation buttons
  5. Multi-column sorting
  6. Searching in the filter pane (this blog)
  7. Line charts can now have a dual axis
  8. The new DAX COALESCE function
  9. Changes to ArcGIS
  10. Query Diagnostics
  11. Generating embed codes is now turned off by default

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 Andy Brown on 14 March 2020

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.

Searching in the filter pane

A bit of a niche feature this - you can now search in the filter pane:

Searching filters

You can use this new Search box to find a filter.  In this example I'm filtering by quantity and region, but might want a way to show these filters easily. 

 

Setting filters

As an exampe, if I type in an N into this search box I get this:

Filter search results

I can now see all filters containing an N.

 

If more ambitiously I type Name, I get this:

Filters containing Name

I can now expand the filter card I want to edit.

 

Formatting the search box

You can change the background colour and text size for the search box:

Search text formatting

Click on the background of your page, and use these two properties at the bottom of the Filter pane card to format the search box.

 

This doesn't have to be tasteful:

Pink search box

That's better!

 

Turning the search box off

When you publish your reports, you may well want to hide the search box.  It would be nice if this was a simple property, but it isn't.  Instead, you have to untick this box in your report's settings:

Disabling the search box

Irritatingly, this isn't a global setting, so I presume you have to untick it for each report that you create.

The Microsoft update page credits this feature to an intern who is joining the Power BI team.  It does feel like a solution in search of a problem!

This blog has 0 threads Add post