BLOGS BY TOPIC
BLOGS BY AUTHOR
BLOGS BY YEAR
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.
- The March 2020 Power BI Desktop Update
- The new ribbon is live (sort of)
- Page navigation buttons
- Drill-through navigation buttons
- Multi-column sorting
- Searching in the filter pane (this blog)
- Line charts can now have a dual axis
- The new DAX COALESCE function
- Changes to ArcGIS
- Query Diagnostics
- 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:
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:
I can now see all filters containing an N.
If more ambitiously I type Name, I get this:
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:
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:
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:
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!
- The March 2020 Power BI Desktop Update
- The new ribbon is live (sort of)
- Page navigation buttons
- Drill-through navigation buttons
- Multi-column sorting
- Searching in the filter pane (this blog)
- Line charts can now have a dual axis
- The new DAX COALESCE function
- Changes to ArcGIS
- Query Diagnostics
- Generating embed codes is now turned off by default