Showing posts with label 2018 Update. Show all posts
Showing posts with label 2018 Update. Show all posts

Friday, July 6, 2018

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,




Friday, June 22, 2018

How do you configure Donut labels inside or outside the donut?

Again this feature is available in the June 5, 2018 update of Power BI.

Visual appeal is really important and Power BI now supports labelling inside or outside the Donut and Pie charts.

We use the same data used in the previous example of controlling the inner radius of Donut control used in data visualization described in this post.

Here the labels are outside the Donut.


Here is how you make them move inside the Donut.


You can also have label's text to overflow if it is not contained.

Some labels inside and others outside.


Overflow set to Off.


In the same way PIE Charts are also handled.