Power BI blogs from Wise Owl (page 1 of 3)

Showing blogs 1-20 (out of 53)

A summary of recent blogs that we've written on bookmarks in Power BI Desktop

Posted by Andy Brown on 18 June 2018

We've created a few blogs giving some ideas for how to use the new Power BI bookmarks features (including dynamic charts and enabling pagination). This blog brings the links together onto a single page.

Using the CROSS FILTER function in Power BI Desktop

Posted by Sam Lowrie on 13 June 2018

Learn about the perils of changing the cross filter direction to "Both", then discover why the CROSS FILTER function is better!

Changes in the June 2018 Update of Power BI Desktop

Posted by Andy Brown on 09 June 2018

There are hardly any changes in this update - the only significant one is that you now sort and filter data within Power BI Desktop itself, rather than having to go into Query Editor.

More suggestions for how to use bookmarks

Posted by Sam Lowrie on 09 June 2018

Another set of examples showing ways in which to use the weird and wonderful bookmarks feature in Power BI Desktop

Splitting long tables of data into different pages (pagination)

Posted by Sam Lowrie on 01 June 2018

This blog shows how you can split rows in tables into different pages, making the data easier to read.

How to create dynamic report titles in Power BI Desktop

Posted by Sam Lowrie on 01 June 2018

How you can combine the use of measures and cards to create dynamic report headers in Power BI Desktop.

Weighted and numeric distribution in Power BI Desktop

Posted by Sam Lowrie on 18 May 2018

Learn to use the SUMMARIZE and CALCULATE functions to produce numeric and weighted distributions.

A summary of new features added to Power BI Desktop in the May 2018 update

Posted by Andy Brown on 14 May 2018

New features introduced into Power BI Desktop in this update include conditional formatting by different fields, the inclusion of filters in drill-through and minor improvements to line and funnel charts.

What is new in the April 2018 Power BI Desktop update

Posted by Andy Brown on 07 April 2018

This month's update allows users to add customisable buttons to a report, incorporates a numeric slicer and includes a few other smaller changes.

Some suggestions for possible uses for bookmarks in Power BI Desktop

Posted by Sam Lowrie on 24 March 2018

This blog gives some suggestions for how you might use the new bookmarks feature in Power BI Desktop.

New features in the March 2018 update of Power BI Desktop

Posted by Andy Brown on 20 March 2018

By far the biggest new feature in the March 2018 update of Power BI Desktop is bookmarks (so big, in fact, that it gets a summary treatment in this blog and a separate, longer blog all to itself).

Learning bookmarks in Power BI Desktop

Posted by Sam Lowrie on 14 March 2018

You can use bookmarks to take your reports to the next level - they take a while to get used to, as this blog shows, but they're worth the hassle!

5 interesting custom visuals in Power BI Dektop

Posted by Sam Lowrie on 12 March 2018

Basic Power BI Desktop visuals can leave something to be desired. Try these 5 visuals to spice up your reports!

New features in the February 2018 update of Power BI Desktop

Posted by Andy Brown on 15 February 2018

You can now search for formatting properties, have slicers which work across pages and create quick measures, among other new features.

New features in the January 2018 update of Power BI Desktop

Posted by Andy Brown on 11 January 2018

This month introduces a smorgasbord of small but useful updates, including the ability to hide pages, colour data labels and to set the anchor (from) date for a relative date slicer.

How to use an unpivot transform in Power BI Desktop (or PowerPivot) Query Editor

Posted by Andy Brown on 04 January 2018

If you get data in pivot (two-dimensional) form, you can unpivot it to get the underlying rows, and hence produce charts and visuals. This blog shows how!

New features in the December 2017 update of Power BI Desktop

Posted by Andy Brown on 04 January 2018

Field descriptions anyone? This is a fairly minor update, although we like responsive horizontal slicers, and there are some exciting things coming up in preview mode.

How to write an M formula to convert Julian dates using Power Query

Posted by Andy Brown on 08 December 2017

This short blog explains how to convert Julian dates to "normal" ones, and how the formula used actually works!

How to reuse a query created in Query Editor or Power Query

Posted by Andy Brown on 29 November 2017

This short blog explains how you can copy and paste the steps of a query that you've created in Power Query (within Power BI Desktop). The steps also work for queries created in Power Query within Excel.

Tags:   Excel | PowerPivot    |    Power BI Desktop | Query editor

A summary of the new features of Power BI Desktop introduced in November 2017

Posted by Andy Brown on 15 November 2017

There's not too much to whet the appetite here: most of the changes are extensions to existing features, such as conditional formatting and column-by-example.

This page has 1 thread Add post
23 Jun 18 at 07:59

Hi Andy,

I'm a little confused about Power BI.  Looking at your videos, it seems Power BI is a collective term for PowerPivot, Power Query, Power Map, etc.

However, googling Power BI, I see this, where the video shows a completely independent tool aimed at creating dashboards and reports, so can you please clarify what is Power BI?  Thanks.

23 Jun 18 at 16:14

Microsoft haven't helped with their naming convention!  They keep changing what Power BI refers to.  Here's where we're at now ...

Power BI is a standalone desktop product, previously known as Power BI Desktop.  You can use these to create reports, and publish them to the web.

PowerPivot runs within Excel, and allows you to link different data sources together to create a data model, and use this as a basis for pivot tables.  PowerPivot used to be one of the Microsoft Power BI tools, but they seem to have quietly dropped this title.

So when Microsoft refer to Power BI, they now refer to creating reports in the standalone Power BI application, perhaps using Power BI Pro, and publishing these to the Internet.  

Hope that's clear ... !