What are the new features in the June 2018 update of Power BI?

Get the latest June 5, 2018 version of Power BI Desktop from here:

https://powerbi.microsoft.com/en-us/desktop/?WT.mc_id=Blog_Desktop_Update

Get all the Power BI related posts on this site:

HodentekMSSS -Pure SQL Server

Get the version suited to your architecture.

List of new features and stuff (copied from Power BI site):

Here’s the complete list of June updates:

Reporting

• High contrast support for reports
• Donut radius control
• Pie and donut detail labels position control
• Format data labels separately for each measure in a combo chart
• Longer phone reports

Custom visuals

• Organization Chart
• China Heat Map

Modeling

• Filtering and sorting in data view
• Improved locale formatting

Data connectivity

• SAP BusinessWarehouse connector improvements
  • New driver and improved performance
  • Improved support for hierarchy variables
• Spark connector now supports Windows Authentication
• OData V4 connector enhancements
• ODBC connector improvements
  • Folding support for Top Rows
  • Ability to filter navigation by DSN catalog

Other

• National cloud selector

How to add a SLICER to my report in Power BI?

SLICER control provides filtering capability to the report, both Basic and Advanced.

Here is a clustered column chart from one of my previous posts.
The data of Male/Female/Total populations for several states in India is shown.

This uses a Clustered Column chart shown.

The next image shows the data behind the above report.

Only very few of the Indian States haven been chosen for the report and if you had had all of the States in this view it will be more crowded. Now how do I just filter a State from this report. You can do this by adding a SLICER (shown in the next image and you find thiss under VISUALIZATIONS).

You click and add the SLICER. The SLICER gets added to the report as shown. Here is a List of all STATES in the report. Instead of a List , you could also opt for a Drop-down list.

Now using the Basic filtering you can manipulate the report to show the one for the STATE you choose in the LIST as shown (Herein PUNJAB is chosen).

In addition to Basic you also have Advanced filtering where you can impose further conditions on your choice for the states.

Using the condition that the STATE name starts with 'C', the number of States is reduced. Now you can choose from this reduced LIST.

Can you sort and filter data in Power BI?

Actually this is one of the new features in the June 5, 2018 update of Power BI. In the other posts 1 , 2 ()you can review enhancements to Donut and Pie charts.

Here in, the improvements in this update allows you to sort columns and filter them ver effectively.
I am using the data of from Indian Census from one of my earlier posts here .
https://en.wikipedia.org/wiki/Demographics_of_India

This was imported into MS Excel and it was in turn imported into Power BI.
The data in Excel is shown here:

Sort_Filter_0
The data from this post is as shown in Power BI:

Sort_Filter_1

In the June 5, 2018 Power BI used here, you can sort and filter in each column.

Column 2 which is text (name of Indian State), you have the sort option come up when you
click the column2's handler as shown.

Sort_Filter_2

For Columns 3 to 5, you have other filtering options as well as sorting:

For example if you choose to filter in the state column(Column2). Here only states starting with 'A' are chosen.

When you agree for this filter by clicking OK, you would see this,