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

Showing blogs 1-20 (out of 141)

Creating picture charts in Power BI using the Infographic Custom Visual

Posted by Andy Brown on 19 May 2021

Want to use your pet's picture for a column chart? This blog shows how to create stacked picture charts in Power BI using the powerful Infographic custom visual.

Tags:   Power BI | Visualisations

Power BI Desktop update for May 2021

Posted by Andy Brown on 19 May 2021

May's update to Power BI Desktop is a big one, encompassing new ways of viewing models, tables and fields, a new text box, smart narratives (to explain data) and a new anomaly detection feature (to explain exceptions).

Tags:   Power BI | Updates

Details of the Power BI Desktop Update for April 2021

Posted by Andy Brown on 28 April 2021

The April 2021 update to Power BI Desktop makes it easier to load text, CSV, JSON and Excel files and includes a wider range of shapes, with more drawing effects

Tags:   Power BI | Updates

Solving FAILED TO DECRYPT CREDENTIALS message when running Power BI

Posted by Sam Lowrie on 20 April 2021

Following the April 2021 update to Power BI (perhaps coincidentally) we started getting this message appearing on our computers, blocking us from running Power BI. Here is how to solve this!

Tags:   Power BI | General

Power Query Online now supports flow diagrams!

Posted by Andy Brown on 24 March 2021

A life-changing (or at least job-changing) new software update from Microsoft - you can now see a visual view of data flows in Power BI (at least in the online version, anyway).

Power BI Desktop - March 2021 Update

Posted by Andy Brown on 24 March 2021

There are two tiny changes in the March 2021 update - X-axis constant lines and a couple of tweaks to DAX - but still the big logjam of changes remains in preview.

Tags:   Power BI | Updates

Colouring the table row for a selected item in Power BI

Posted by Andy Brown on 22 March 2021

How can you highlight the row in a table corresponding to the slicer value you've chosen? With a disconnected slicer and a clever measure!

Tags:   Power BI | Measures / DAX

Changes to Power BI in the February 2021 update

Posted by Andy Brown on 26 February 2021

After no update in January, February sees just a couple of small changes to Power BI, but there's a big logjam building up in preview.

Tags:   Power BI | Updates

Showing DAX Studio and Tabular Editor as external tools in Power BI

Posted by Andy Brown on 23 February 2021

Power BI automatically creates an External Tools ribbon when you install the Power BI, Tabular Editor and ALM Toolkit add-ins.

Tags:   Power BI | Measures / DAX

DAX.DO - a replacement for DAX Studio?

Posted by Andy Brown on 22 February 2021

The legendary Marco Russo has launched a new web-based DAX editor, but can it compete with or even replace DAX Studio?

Tags:   Power BI | Measures / DAX

Errors when you delete a primary key in Power BI

Posted by Andy Brown on 22 February 2021

Be careful of referencing measures in calculations when you have duplicate rows in a table! This blog explains why you might want to hang on to that unused primary key column.

Tags:   Power BI | Measures / DAX

How to use DAX to show for each row of a table its share of the maximum value

Posted by Andy Brown on 22 January 2021

How can you show each aggregate value in a group as a percentage of the highest aggregate value? This blog shows two ways to use DAX measures to solve this deceptively difficult problem.

Tags:   Power BI | Measures / DAX

Using a DAX query to show a table in Power BI

Posted by Andy Brown on 14 January 2021

Did you know that you can write an EVALUATE DAX query in software like DAX Studio and then run it from within Power BI to create a new table? You do now!

Tags:   Power BI | Measures / DAX

A new type of Power BI licence: Premium per user

Posted by Andy Brown on 05 January 2021

Microsoft have announced a new type of licence for Power BI called Premium Per User, which sits halfway between the current Pro and Premium licences.

Tags:   Power BI | General

What Power BI report server is, and how to create reports through it

Posted by Andy Brown on 23 December 2020

Puzzled as to why there are two near-identical versions of Power BI Desktop? Wondering if web portal is anything like Power BI report server? Confused as to what a paginated report is? This blog answers all these questions, and more!

Tags:   SSRS | Report Manager    |    Power BI | General

With no big updates for December 2020, this blog looks at a preview feature

Posted by Andy Brown on 22 December 2020

There aren't any interesting or noteworthy new additions to Power BI this month, so this blog instead looks at an exciting new feature which has just appeared in preview: small multiples.

Tags:   Power BI | Updates

How to add cumulative totals to a visual using DAX measures in Power BI

Posted by Andy Brown on 02 December 2020

Inspired by a question from a course, in this blog Andy Brown builds up a measure to show cumulative totals for a calendar matrix, dotting his DAX i's and crossing his t's!

Tags:   Power BI | Measures / DAX

Playing the Harry Potter escape room game in Power BI

Posted by Andy Brown on 27 November 2020

This awesome game shows what's possible using bookmarks in Power BI (think of it as the sequel to Sam's 2019 Pin the Tail on Rudolf game).

Tags:   Power BI | General

The November 2020 update includes zoom sliders and a better apply filter button

Posted by Andy Brown on 27 November 2020

This month's update allows you to zoom in on a particular part of a chart using sliders, and also lets you save up filters to apply them all in one go.

Tags:   Power BI | Updates

Two easy ways to create themes in Power BI without needing to write JSON

Posted by Sam Lowrie on 30 October 2020

This blog show two ways in which you can create custom themes in Power BI without needing to learn how to write JSON: either use the built-in theme editor in Power BI, or use the theme generator from Power BI Tiips.

Tags:   Power BI | General
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 ... !