Wise Owl Blogs - Home (page 2 of 19)

Showing blogs 21-40 (out of 370)

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.

Tags:   Power BI | Visualisations

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.

Tags:   Power BI | Measures / DAX

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.

Tags:   Power BI | Measures / DAX

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.

Tags:   Power BI | Updates

Use the Excel camera tool, or create a linked picture in Word or PowerPoint

Posted by Andy Brown on 25 April 2018

This blog shows options for creating a webcam focused on one particular area of an Excel workbook! You can do this either by pasting the Excel range into PowerPoint or Word as a linked picture, or by using the Excel camera tool.

Tags:   Excel | General

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.

Tags:   Power BI | Updates

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).

Tags:   Power BI | Updates

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!

Tags:   Power BI | Visualisations

How to get rid of lots of blank rows in a Report Builder table

Posted by Andy Brown on 16 February 2018

There seems to be an occasional bug in Report Builder which fills a table with blank rows. Here's one owl's way to get round it.

Tags:   SSRS | Report Builder

Which should you learn: Report Builder or Reporting Services?

Posted by Andy Brown on 16 February 2018

Report Builder and SQL Server Reporting Services are almost identical - which makes the small but important differences even harder to explain.

Tags:   SSRS | Report Builder    |    SSRS | General

Did you know there was an IIF function in SQL to test conditions? We didn't!

Posted by Andy Brown on 16 February 2018

You can use the IIF function in SQL as an alternative to the CASE WHEN statement. We thought we would share this new (for us) discovery with the world!

Tags:   SQL | Calculations

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.

Tags:   Power BI | Updates

How to use the Windows Magnifier to zoom in on parts of your screen

Posted by Andy Brown on 29 January 2018

If you're trying to project your screen at the front of a class, the Windows Magnifier lets people see what you're doing more easily.

Tags:   Musings | General IT

What's new in SQL Server 2017? For SSAS Tabular, lots, it transpires.

Posted by Andy Brown on 23 January 2018

This blog summarises the main new features of SQL Server for non-administrators (that is, most of us). Most parts of SQL Server get minor changes at best, but SSAS Tabular 2017 gets a host of major improvements.

A summary of the changes introduced in Visual Studio 2017

Posted by Andy Brown on 19 January 2018

Visual Studio 2017 includes some clever new quick coding features, better debugging and a much better installation routine, as this blog explains.

Changes to Wise Owl Excel courses (including a new intermediate course)

Posted by Andy Brown on 15 January 2018

We've revamped our Excel course offerings, to include a new one-day Intermediate Excel course to sit between our introduction and advanced courses.

Tags:   Excel | General

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.

Tags:   Power BI | Updates

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!

Tags:   Power BI - Excel | Power Query    |    Power BI | Query editor
This page has 0 threads Add post