Category: Power BI

10th July 2020

Power BI – Personalize Visuals

The May 2020 update for Power BI includes the option for a report reader to personalize visuals and save the changes as a bookmark.

Categories Power BI/Updates/YouTube

22nd June 2020

Power BI Introduction Resources

This post is to support my virtual session at London Reactor on 22nd June. It will include the recording and links to the data source and the final Power BI Report. Link to Reactor Recording will go here…. Data Used and Final File Data in a single Excel File Final PBIX File Links to great Resources Guy in a Cube...

Categories Power BI

31st May 2020

Power Apps – Embed a Power BI Chart

This post covers how to embed a Power BI chart from a published report into a Power App, handling a tile that doesn’t appear and then filtering the embedded chart.

Categories How to/Power BI/PowerApps/YouTube

15th April 2020

Power Query – Replace values for whole table

Today’s challenge was to replace the values on all the columns in the query when I know the columns will change so I don’t want to name them.

Categories M/Power BI/Power Query

3rd April 2020

Power BI – COALESCE Function to Remove Blanks

This post walks through a simple use of the coalesce function to prevent a measure returning Blank. This function was introduced to Power BI in March 2020.

Categories Power BI

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.

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

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

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

Categories Power BI/Project

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

Categories M/Power BI/Power Query