All courses REMOTE until June 30 | Limited in-class sessions in June - Call Us | From July 1 all courses available in-class and remotely

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.

What is Remote Training?

Valued by Individuals

 

4.8/5
Over 20822 Reviews
Great Explanations, Very Helpful, Highly recommend. -Excel Intermediate Perth
Luke - Excel Intermediate, .
Jagg was really great, good amount of detail and a good pace, made it easy to keep up and really learn everything. Thank you -Excel Intermediate Sydney
Madelene - Excel Intermediate, .
Great communication skills -Excel Intermediate Perth
Anthony - Excel Intermediate, .
. -Office365 Intermediate Sydney
James - Office365 Intermediate, .
Helpful and well explained -Office365 Intermediate Sydney
Monika - Office365 Intermediate, .
John was really good at power BI and some of the concepts were great. I will keep all these details close by and even reach out to John if I have further questions. Thanks for the day! -Power BI Advanced Canberra
Matthew - Power BI Advanced, .
Thanks -Power BI Advanced Canberra
Gabriela - Power BI Advanced, .
The training was really great. Jag kept us engaged for the whole day which is great. I learnt a lot and can't wait o put the tips and tricks in action. Thanks -Excel Intermediate Sydney
Rosalind - Excel Intermediate, .
Jag is so very good! Was very engaging and actually very fun! -Excel Intermediate Sydney
Michelle - Excel Intermediate, .
Good overall -Power BI Advanced Canberra
YuinAi - Power BI Advanced, .
Michael was great - he had a good pace and checked in with us to see if we had any questions. He is clearly very passionate about Power BI which enhanced the whole experience -Power BI Beginner Sydney
Ally - Power BI Beginner, .
It was very informative and Michael was very helpful and detailed. -Power BI Beginner Sydney
Alan - Power BI Beginner, .
Very good introduction to PowerBI. Concepts very well explained. -Power BI Beginner Sydney
Eric - Power BI Beginner, .
Thanks Ken, very informative. -PowerPoint Level 2 Sydney
David - PowerPoint Level 2, .
Thank you was a great session. -PowerPoint Level 2 Sydney
Nikita - PowerPoint Level 2, .
Really useful tips and shortcuts -PowerPoint Level 2 Sydney
Devlin - PowerPoint Level 2, .
Thanks- great course! -PowerPoint Level 2 Sydney
Gabrielle - PowerPoint Level 2, .
Helpful. Thank you very much. -PowerPoint Level 2 Sydney
Guida - PowerPoint Level 2, .
Wonderful course. Enjoyed it very much and learnt many new features -Power BI Beginner Sydney
Victor - Power BI Beginner, .
. -Power BI Beginner Sydney
Steve - Power BI Beginner, .

Trusted by Business

Procured by Government

Map of Australia