Category: Power BI

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.

Categories M/Power BI/Power Query

29th September 2019

Power Query – Multi-step Function

This post describes how to build a multiple step function in M using a parameter and using create function to build the function code.

Categories M/Power BI/Power Query

27th September 2019

Power Query – Custom Handwritten Function

In this post I will write a simple custom handwritten function to perform a calculation, which can then be used in your queries.

Categories Intermediate/M/Power BI/Power Query

13th August 2019

SVG in Power BI Part 7 – Using a Theme to add SVG Icons

As part of the July 2019 update there were changes to conditional formatting. In this post I am going to cover adding to or swapping the built in icons using a theme file and some SVG.

Categories Power BI/SVG/Updates

6th August 2019

SVG in Power BI Part 6 – New Icon Conditional Formatting

In July 2019 Power BI Desktop update they included new conditional formatting on table and matrix to include icons. These icons can be defined using SVG which is pretty cool. So this is a new post in my Power BI SVG series looking how we can use SVG icons in conditional formatting.

Categories Power BI/SVG/Updates

27th July 2019

Power BI – DAX CrossFilter Function

In this post I am continuing my campaign against bi-directional relationships. This is an introduction of the CROSSFILTER function which can be used to simulate the bi-directional relationship in a calculation.

Categories Power BI

26th July 2019

Power BI – Cascading Slicers

In this post I will look at filtering one slicer based a selection in another slicer. June 2019 Power BI Update included an update to allow a slicer to be filtered based on a measure, which means that you no longer need to use bi-directional relationships.

Categories How to/Power BI

25th July 2019

Power BI – Using inactive relationships in a measure.

In this post I will show a simple example of how to use a different relationship between two tables in a measure. The example I will use is a list of tasks with start and finish dates. The request is for how many tasks start per week and how many finish per week to be plotted on a column chart.

Categories Intermediate/Power BI

9th July 2019

Power BI – Data Refresh Date

In this quick post I will walk through adding a data refresh date on a report page in Power BI.

Categories How to/Power BI

13th June 2019

Power BI – Conditional Formatting Update

The June 2019 update for Power BI included a few updates for conditional formatting, for visual backgrounds, titles, cards and gauges. This post is my take on the updates and on how I prefer to do the logic behind choosing a colour.  Full details of the June 2019 update can be found at https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-june-2019-feature-summary/ Applying Conditional Formatting  This update added...

Categories Power BI/Updates