Hat Full of Data

25th March 2020

Power BI – Introducing the Hierarchy Slicer

The new hierarchy slicer allows for data to be sliced based on different levels. This will reduce the number of slicers required on a report page.

How to/Power BI

9th March 2020

Power BI – Reset Slicers with a Bookmark Button

When your report has a bunch of slicers and charts that can also add filters to the page resetting back to no filters can be painful. So we need a quick way to reset slicers. This post walks through the steps of creating a bookmark and the using that bookmark to reset the page by clicking a button. Introduction This...

Introduction/Power BI

6th March 2020

Power BI – Slicer Introduction

Power BI reports can be made more flexible using simple slicers to allow your report consumers to slice and dice the data shown.

Power BI

21st January 2020

Power BI – Connecting to Project Online

This post walks through connecting to Project Online to visualise the data in Power BI. This is the first post in a series of building a set of reports.

Power BI/Project

27th December 2019

Power Apps – 12 Days of Components

This post is to provide the code and resources to support my 12 Days of Components videos which use SVG to create a range of graphics.

Components/PowerApps/SVG/Uncategorized

23rd November 2019

Power Apps – Animating SVG Fill Colour and Size

In this post I will introduce animating SVG by altering the colour and size of the SVG graphic using variables and a timer control.

PowerApps/SVG

26th October 2019

PowerApps – Function Component

In this post I write a simple function component that takes one value and returns a calculated value. This creates a resusable function like feature.

Components/How to/PowerApps/SVG

25th October 2019

PowerApps – SVG Introduction

In this SVG Introduction post we will cover adding a simple SVG drawing to a PowerApp screen. Future posts will show how to manipulate that image.

PowerApps/SVG

6th October 2019

Power Query – Function to Execute an SQL Procedure

This is the fourth post in my series regarding writing custom functions in Power Query. This post describes how to create a function that will execute an SQL procedure, passing in a parameter. Stored Procedure My database contains a very simple procedure that given a cost center returns all the expense records. It can be run with the following SQL...

M/Power BI/Power Query

5th October 2019

Power Query – Building functions to fetch web data

Often web based data is split across multiple pages. This post describes how to use a function to fetch web data from multiple pages by using parameters.

M/Power BI/Power Query