Power BI Desktop update – feature of the month (Jun 18)

Here’s a summary of the updates Microsoft released for Power BI in June 2018. Full details on this months updates can be found on the Power BI blog.


The feature we’ve picked out as the highlight for this month is the filtering and sorting in data view. Watch the below video to see this feature in action, the video will automatically start and end in the relevant place.

This will not necessarily be the most exciting feature for those wanting to present data in new and interesting ways, but for those developing calculated columns and measures in Power BI this will be a very welcome addition.

When developing calculated columns and measures in Power BI, it often helps the developer if they can restrict the data in data view mode to the data they are specifically interested in at that time. For example, the developer may want to include/exclude certain data from their calculation. In this scenario, and by using data view filtering and sorting, the developer can clearly see the rows they’re about to include/exclude. Power BI will also provide the developer with some high level information about these rows, including; number of rows and the number of distinct values.

It would be really nice if in a future release a subtotal for all Fact columns affected by the data view filter could be displayed as well. This may help a developer quickly and easily validate a calculation they’ve added to their data set.

It’s important to note that any filters or sorts that are applied in data view are not carried forwards to the report. We’ve been able to filter data in Edit Query mode for some time, and these filters do carry through to both the data set and the report – so it may be easy to get confused.

For those who are more interested in visualisation data in new and interesting ways, the Organisation Chart custom visualisation listed above may be worth looking at. This may be particularly interesting if, for example, there’s data associated to each entity (person most likely) in the Org chart.  For example, you may be able to use it to select a person and then see a summary of the tasks assigned to them (we haven’t tried and tested this yet, but we will do soon).

Do you agree? Perhaps you’d pick a different feature, or the same feature for different reasons. Either way we’d love to hear your thoughts on this.

We hope you found this useful and/or interesting. If so please like, share or comment.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s