This page has 1 thread | Add post

Blogs

Finding our blogs useful? Please consider helping us to share more!

Power platform blogs from Wise Owl (page 7 of 8)

Showing blogs 121-140 (out of 154)

Writing an App in Power Apps

Posted by Sam Lowrie on 26 June 2020

Sam was tired of getting told off for crinkled or missing expense receipts. So he had a look at Power Apps and this is what he found…

Tags:
Power BI > General

Add the ComicGen custom visual to your Power BI reports to spice them up!

Posted by Andy Brown on 27 April 2020

The ComicGen custom visual allows you to show one of two characters (Dee or Dey) in a variety of poses, and with a range of emotions. Excitingly, the poses and emotions can depend on your data, making these the most human of KPIs. Find out more in this blog!

Tags:
Power BI > Visualisations

How to show rows with no corresponding data in a Power BI visual

Posted by Andy Brown on 12 March 2020

This modest blog explains how you can tell Power BI to show all of the members of a dimension table (even the ones which have no corresponding data).

Tags:
Power BI > Visualisations

Our series of Simple Talk tutorials on using DAX within Power BI is now complete

Posted by Andy Brown on 13 February 2020

Simple Talk provide excellent how-to guides on any aspect of Microsoft software. We are proud to have contributed a series of articles explaining how to create DAX calculated columns and measures within Power BI.

Tags:
Power BI > Measures / DAX

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!

Tags:
Power BI > General

Dynamic comparison calculations in DAX

Posted by Sam Lowrie on 08 November 2019

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

Tags:
Power BI > Measures / DAX

Explaining the VALUE argument of the RANKX function in DAX

Posted by Sam Lowrie on 28 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!

Tags:
Power BI > Measures / DAX

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.

Tags:
SSRS > General Power BI > General

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.

Tags:
Power BI > Data sources

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.

Tags:
Power BI > Updates

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!

Tags:
Power BI > Query editor

Creating complex custom date periods in calendar tables using calculated columns

Posted by Sam Lowrie on 15 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.

Tags:
Power BI > Dates and calendars

Creating a calendar or date table in Power BI using built-in calendar functions

Posted by Sam Lowrie on 15 May 2019

Learn how to create a basic date table in Power BI, using either the CALENDAR or CALENDARAUTO functions, and also learn how to then add custom columns of your own.

Tags:
Power BI > Dates and calendars

Modelling a fixed or variable custom financial year in Power BI

Posted by Sam Lowrie on 15 May 2019

Whether your financial year ends on a fixed date every year or on the first Monday in June, this blog will show you how to incorporate it into your calendar table.

Tags:
Power BI > Dates and calendars

Getting Started with Power BI Report Server

Posted by Andrew Gould on 07 July 2023

Power BI encourages you to publish reports to an online service so that you can share your beautiful reports with the world. If you'd rather keep them a secret you can use Power BI Report Server to deploy your reports to an on-premises server, as this blog series shows you.

Tags:
Power BI > General Power BI > Power BI Service

The mysteries of context transition explained

Posted by Sam Lowrie on 22 February 2019

Context transition happens when a DAX function creates filter context within row context, or vice versa. This blog explains what context transition is, and shows which DAX functions make use of it.

Tags:
Power BI > Measures / DAX

Understanding row context in DAX

Posted by Sam Lowrie on 29 January 2019

Row context (along with its sibling, filter context) is one of the most important concepts in DAX. This blog explains what row context is, and how to use it!

Tags:
Power BI > Measures / DAX

Understanding filter context in DAX

Posted by Sam Lowrie on 25 January 2019

Understanding filter context is the key to understanding how to create measures in DAX. This blog aims to explain this vital subject as succinctly as possible!

Tags:
Power BI > Measures / DAX

Creating reports in Power BI with dynamic measures or dynamic dimensions

Posted by Andy Brown on 03 January 2019

This blog shows how to create fully dynamic reports, whereby users can choose which statistics to show and which dimensions to report them by.

Tags:
Power BI > General

Showing the top N values of a dimension, where you can use a slicer to vary N

Posted by Andy Brown on 06 December 2018

Following a question from a Power BI course, this blog shows how you can get a page to show the top N customers by sales value, where N is a number controlled by a slicer.

Tags:
Power BI > Measures / DAX

This page has 1 thread

Add a new post

From:	duggie
When:	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.

From:	Andy B
When:	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 ... !

Add a new post

BY TOPIC