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 22963 Reviews
It is the 1st time that I use Power BI and at the end of the training session I have gained a good knowledge. Ken was organised and helpful. -Power BI Beginner Canberra
Kumara - Power BI Beginner, .
Very helpful and easy to understand. -Excel Advanced Perth
Bennett - Excel Advanced, .
Another great workshop with Dom, always helpful and keeps things exciting. Very knowledgeable and a great teacher. -Excel Advanced Perth
Felix - Excel Advanced, .
Learnt so much! -Excel Advanced Perth
Shay - Excel Advanced, .
Excellent course. Well delivered and informative. -Excel Advanced Perth
Stephen - Excel Advanced, .
Great course and instructor! -Excel Advanced Perth
Tara - Excel Advanced, .
Thank you Michael. You are Very supportive, I hope with your little help I will be able to put my BI training to real use Best Regards, -Power BI DAX Sydney
Gurwinder - Power BI DAX, .
A great course - covered a lot & Michael is very knowledgeable & patient! -Power BI DAX Sydney
Lauren - Power BI DAX, .
Lot of content, Michael was easy to follow and very helpful. I have lots to take back to work an d practice. I note that we didn't go through the book as it is laid out and there are probably a lot of exercises that we didn't get time to do. I expect that this will need to be done in our own time later. I think this course can be stretched over 2 days. -Power BI DAX Sydney
Fiona - Power BI DAX, .
Very useful course and excellent tutor. Keen to know more about DAX Studio. -Power BI DAX Sydney
Lina - Power BI DAX, .
Great trainer, really engaging which is difficult in a virtual environment. Covered a lot in one day, and looking forward to the next course. -Power BI Beginner Adelaide
Kelleigh - Power BI Beginner, .
Jagg explained everything clearly and in a very logical order which helped with understanding the intricacies and end result of the package. He handled the hybrid teaching environment (online and face to face) very well. -Power BI Beginner Adelaide
Suranie - Power BI Beginner, .
Well paced, easy to follow, engaging presentation -Power BI Beginner Adelaide
Nathaniel - Power BI Beginner, .
Good tutorial class. Learnt a lot! -Power BI Beginner Adelaide
Julian - Power BI Beginner, .
A great foundation for an introduction to Power BI. -Power BI Beginner Adelaide
Jason - Power BI Beginner, .
-Power BI Beginner Adelaide
darren - Power BI Beginner, .
This course was very informative for someone who is very familiar with Excel and self-taught but wanting to fill in the gaps and expand their knowledge even more. Steven was a brilliant trainer - he spoke clearly and slowly (which really helps when doing this course online) and made sure that everyone in the session was following each step. And his virtual chocolate frogs were much appreciated! Thank you so much! -Excel Advanced Brisbane
Rebecca - Excel Advanced, .
Good Introduction to advance features, would like to extend to the next level which is probably more aligned to the specialist courses. Key Goals achieved - 7 efficiency options in modelling identified. -Excel Advanced Brisbane
Robyn - Excel Advanced, .
Stephen was easy to follow and doing it on line was a great experience. -Excel Advanced Brisbane
Helen - Excel Advanced, .
Steven was a fantastic teacher - explained things clearly and checked in. His also took the time to find out what we do for work and try to tailor what we focused on based on those needs or highlight when what we were learning may be especialy applicable to certain people. The course is great with the resources to play with - i got a lot out of it Virutal chocolate frogs for Steven! -Excel Advanced Brisbane
Shakira - Excel Advanced, .

Trusted by Business

Procured by Government

Map of Australia