All courses available in-class or via remote login

What's new in Power BI

What’s new in Power BI 2018

February 22, 2018

Power BI February Update

According to the Microsoft Power BI website there are two major themes for the Power BI February update. The first theme is a focus on some of the 'major asks' they have been requested to improve in the program. These include multi-selecting data points across multiple charts and syncing slicer values across multiple pages of your report. There has also been a major update to the SAP HANA connector. The second theme is a focus on performance improvements. See below for two of our favorite updates plus a list of all the February updates.

Multi-select data points across multiple charts

Multi-selecting data points across multiple charts was one of the most highly asked for features that has now come to fruition. You can now ctrl + click on data points in multiple charts and have the cross filters applied to your entire report. As you select data points across multiple charts, they will apply both those filters together.

Sync slicers across multiple pages of your report

Another feature that was highly sought after was to have slicers that apply to multiple pages. To meet this request, Microsoft have added a “sync slicers” pane that will let you select slicers to stay in sync across multiple pages. For instance, selecting “red” on a product color slicer on page 1 will be reflected in the product color slicer on page 2 if the two pages are synced. You can reach the sync slicers pane from the View tab.

Once you’ve opened the pane, select a slicer to see the options. You can quickly make the slicer apply to every page by clicking the ‘Add to all’ link. A hidden slicer will be put on every  page, synced to the currently selected slicer. You can also use the right column to pick if the slicer is visible on each page or not.



To get the scoop on all the updates see the list below:

Reporting

  • Multi-select data points across multiple charts
  • Sync slicers across multiple pages of your report
  • Numeric range slicer improvement – whole number snapping (preview)
  • Faster geocoding for Bing maps (web preview)
  • Overflow data labels for bar and column charts
  • Search the formatting and analytics pane

Analytics

  • Mark custom date table
  • Quick measures are now generally available
  • UTCNOW () and UTCTODAY ()

Custom visuals

  • Organizational custom visuals (preview)
  • Network Visualization and Filter
  • Slope chart by MAQ Software
  • Filter by List
  • As Timeline
  • As T- Accounts

Data connectivity

  • Improvements to DirectQuery over SAP HANA (preview)

Other

  • DirectQuery performance improvements
  • Open and save performance improvements
  • “Show items with no data” improvements
  • Persistent filters control for upcoming Power BI service feature
  • Consulting Services quick link


To learn more about Power BI and Business Intelligence check out our courses here.

Contact Us

What is Remote Training?

Valued by Individuals

4.8/5
Over 25917 Reviews
Great context set up for the course and great presentation by Steven! It helped me to refresh some already used functions and learn new functions that beneficial to my work. Thank you! -Excel Advanced Brisbane
Lu - Excel Advanced, .
Great course, was well paced for my skill level. Stephen is a great trainer, knowledgeable, easy to follow, and easy to listen to. -Excel Advanced Brisbane
Beth - Excel Advanced, .
Steve has once again proved to be an excellent trainer. I appreciated his personal attention to questions and issues raised. He also took the time to investigate additional topics that were beyond the set scope of the course. Great learning experience! -Excel Advanced Brisbane
Cindy - Excel Advanced, .
Very informative training! I feel like I have learnt a lot. Very engaging trainer! :) -Excel Advanced Brisbane
Alexandra - Excel Advanced, .
The training was well presented. Learning more about relative and absolute was great. Working in charts and learning more about trends and forecasting was very helpful. -Excel Beginner Brisbane
Annette - Excel Beginner, .
Course is well structured and presenter very knowledgeable -Excel Beginner Brisbane
Kevin - Excel Beginner, .
Good presentation and educational. -Excel Beginner Brisbane
Wayne - Excel Beginner, .
Wonderful course. Learnt a lot from an extremely knowledgeable instructor. Thank you! -Excel Beginner Brisbane
Emma - Excel Beginner, .
It was good to increase my efficiency using Excel. -Excel Beginner Brisbane
Nathan - Excel Beginner, .
it was a great training session -Excel Beginner Brisbane
Belinda - Excel Beginner, .
Great course, I learnt a lot and have taken away some skills i can use in my workplace. -Excel Beginner Brisbane
Chantelle - Excel Beginner, .
Very informative. Well paced session. Clear instruction. Good foundation of learning. Thank you. -Excel Beginner Brisbane
Hayley - Excel Beginner, .
Even though the session was remote , It was interesting. I really learned lots of tips & shortcuts that could be used in my role . Overall the session was all good. Great session Ken!!! -Excel Customised Melbourne
Shoma - Excel Customised, .
It was quite a good session for me. Pivot Tables & Macros were the two components that I was really interested in, and Ken was marvelous in teaching those. Also there were few major shortcuts which I never knew before, so it was really awesome to know these -Excel Customised Melbourne
Abdul - Excel Customised, .
Good Handy Tips and Tricks. -Excel Customised Melbourne
William - Excel Customised, .
Ken is great, it was easy to understand, his speed was easy to follow. -Excel Customised Melbourne
Selina - Excel Customised, .
Ken was great! Lots of knowledge and went at a great pace. Thanks Ken! -Excel Customised Melbourne
Lely - Excel Customised, .
It was a good session. -Power BI Advanced Melbourne
Ehsan - Power BI Advanced, .
Very good -Power BI Advanced Melbourne
Vinh - Power BI Advanced, .
Was very useful and learnt a lot of new concepts. -Power BI Intermediate Perth
Karthik - Power BI Intermediate, .

Trusted by Business

Procured by Government

Awards and Accreditations

Map of Australia

Follow us