Please note javascript is required for full website functionality.

Blog

Charts and Dashboards: Chart Titles as a Text Box

14 May 2021

Welcome back to this week’s Charts and Dashboards blog series. This week, we will talk about creating a chart title using a text box.


Power BI Blog: Calculating Monthly % Change

13 May 2021

Welcome back to this week’s edition of the Power BI blog series. This week, we will look at how to write a measure to compare the previous month’s collection values to the current month’s collection values.


Power Query: Find a Table

12 May 2021

Welcome to our Power Query blog. This week, I look at what to do when the location of a table is changed.


Power Pivot Principles: PREVIOUSMONTH Comparison

11 May 2021

Welcome back to the Power Pivot Principles blog. This week, we are going to compare monthly data using yet another approach.


A to Z of Excel Functions: The ISERROR Function

10 May 2021

Welcome back to our regular A to Z of Excel Functions blog. Today we look at the ISERROR function.


Charts and Dashboards: Moving Chart Labels – Part 2

7 May 2021

Welcome back to this week’s Charts and Dashboards blog series. This week, we will continue to discuss about the moving chart labels.


Power BI Blog: Gauge Visualisation – Presenting Percentages

6 May 2021

Welcome back to this week’s edition of the Power BI blog series. This week, we will look at how to use the built-in Gauge visualisation to display percentages.


Power Query: Group Text

5 May 2021

Welcome to our Power Query blog. This week, I look at how to modify a grouping statement to accommodate text fields.


Power Pivot Principles: PARALLELPERIOD Comparison

4 May 2021

Welcome back to the Power Pivot Principles blog. This week, we are going to compare monthly data again, but this time using on an alternative approach.


Challenges: Monday Morning Mulling: April 2021 Challenge

3 May 2021

On the final Friday of each month, we set an Excel / Power Pivot / Power Query / Power BI problem for you to puzzle over for the weekend. On the Monday, we publish a solution. If you think there is an alternative answer, feel free to email us. We’ll feel free to ignore you.


Newsletter