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

A placeholder for the January 2020 Power BI Update

Posted by Andy Brown on 16 January 2020

The January 2020 Power BI update isn't out yet, but we will blog about it here as soon as it is announced.

Revelations about Power BI - hiding preview and left-click drill-through

Posted by Andy Brown on 10 January 2020

When we find new features which we didn't know about, we try to share them! Did you know that you can turn preview off when getting data? Or that you could left-click to drill-through? We didn't!

A summary of the main changes introduced in the December 2019 Power BI update

Posted by Andy Brown on 23 December 2019

The December 2019 update allows you to customise your visuals pane and format KPIs better, but that's almost it!

A preview of what the feature to customise themes within Power BI will look like

Posted by Andy Brown on 23 December 2019

Power BI is getting a built-in facility to edit themes, although it is currently still in preview. This blog shows what you can expect.

Pin the tail on the reindeer, Power BI style

Posted by Andy Brown on 12 December 2019

You have 3 attempts to pin the tail on the (slightly caustic) reindeer, a game created by Sam as a Power BI report.

There are few changes in the November 2019 update of Power BI

Posted by Andy Brown on 25 November 2019

The only significant change to Power BI for the November 2019 update is the introduction of conditional formatting for buttons, although there are exciting things now waiting in preview.

A new Power BI ribbon is waiting in the wings!

Posted by Andy Brown on 25 November 2019

Microsoft have announced a new preview version of Power BI ribbon - this blogs shows what it will look like.

Dynamic comparison calculations in DAX

Posted by Sam Lowrie on 11 November 2019

This blogs shows a clever way in which you can use a slicer to choose which values to compare in a measure.

Explaining the VALUE argument of the RANKX function in DAX

Posted by Sam Lowrie on 29 October 2019

The RANKX function does what the name implies - it ranks values based on a calculation. However, the VALUE argument often causes confusion; this blog explains what it does!

Our take on the new features introduced in the October 2019 update for Power BI

Posted by Andy Brown on 20 October 2019

This month's big story is a huge range of improvements to the Q&A feature in Power BI, with more in the preview pipeline. There are also a built-in PowerApps visual, improvements to data profiling in Query Editor and a new template for connecting to datasets.

A comparison of SQL Server Reporting Services and Power BI

Posted by Andy Brown on 18 October 2019

Power BI improves with each monthly update. Will it reach a point where SSRS (SQL Server Reporting Services) becomes redundant? This detailed blog compares the two products, and considers the future of SSRS.

A summary of the changes introduced in the September 2019 update to Power BI

Posted by Andy Brown on 20 September 2019

This month sees the welcome (if belated) introduction of Excel-style custom number formats, as well as more (and easier-to-create) themes and a host of other minor improvements.

Using the new Power BI template app to view Google Analytics data

Posted by Andy Brown on 20 September 2019

How to create a new app to view your Google Analytics data in Power BI Service.

A summary of new features introduced in the August 2019 Power BI update

Posted by Andy Brown on 19 August 2019

This was a month of few updates. Our favourite by far is that you can now group visuals, but the Key Influencers visual has also emerged from the preview shadows.

We have unearthed two new sources of information on future Power BI features

Posted by Andy Brown on 14 August 2019

In addition to the Power BI preview features dialog box, Andy Gould has discovered two excellent new sources of information on forthcoming changes for Power BI, as this blog explains.

New features introduced in the July 2019 update of Power BI

Posted by Sam Lowrie on 02 August 2019

There are big changes to conditional formatting this month (you can display icons, and use percent-based thresholds), but the biggest change of all is the release - finally - of the new filter pane.

How to view the SQL query for a series of transforms in Query Editor

Posted by Andy Brown on 02 July 2019

Did you know that you can view the SQL for a query in Power BI's Query Editor? Me neither!

Changes introduced in the June 2019 Power BI update

Posted by Andy Brown on 14 June 2019

Although there aren't many changes this month, the ones that there are of unusually high quality. The new look to Power BI is welcome (even if it does mean we have to rewrite all of our courseware), and we're looking forward to using the new conditional formatting options and visual header tooltips.

New features introduced in the May 2019 update of Power BI

Posted by Andy Brown on 20 May 2019

There's not much new in this month's update. The Performance Analyzer is a great idea, for working out which bits of your report are running slowly, but all of the other changes are minor (as you'll see if you read this blog!).

Creating complex custom date periods in calendar tables using calculated columns

Posted by Sam Lowrie on 17 May 2019

This blog shows how to create custom date periods within a date table for 28 day cycles, but the principles shown could be applied to create any custom date periods.