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...
Power BI reports can be made more flexible using simple slicers to allow your report consumers to slice and dice the data shown.
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.
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.
In this post I will introduce animating SVG by altering the colour and size of the SVG graphic using variables and a timer control.
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.
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.
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...
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.
This post describes how to build a multiple step function in M using a parameter and using create function to build the function code.