Please note javascript is required for full website functionality.

Blog

Charts and Dashboards: Sparklines

9 October 2020

Welcome back to this week’s Charts and Dashboards blog series. This week, we will consider using sparklines when designing dashboards.


Power BI Blog: Dealing with Overflow on Cards

8 October 2020

Welcome back to this week’s edition of the Power BI blog series. This week, Jonathan Liau looks at how to deal with an overflow of slicer selections on card visualisations.


Power Query: Going for the Record

7 October 2020

Welcome to our Power Query blog. This week, I put the spotlight on records.


Power Pivot Principles: Introducing the ALLNOBLANKROW Function

6 October 2020

Welcome back to the Power Pivot Principles blog. This week, we will talk about the ALLNOBLANKROW in DAX.


A to Z of Excel Functions: The IMLN Function

5 October 2020

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


Charts and Dashboards: Dashboard Design – Using Tables and Conditional Formatting

2 October 2020

Welcome back to this week’s Charts and Dashboards blog series. This week, we will talk about using tables and conditional formatting when designing a dashboard.


Power BI Blog: Ordering Slicer Selections on Cards

1 October 2020

Welcome back to this week’s edition of the Power BI blog series. This week, Jonathan Liau looks at how to order slicer selections that are displayed in a card in Power BI.


Power Query: Almost There

30 September 2020

Welcome to our Power Query blog. We turn 200!! To celebrate, I do nothing other than write another article! This week, I look at how to add a fuzzy column.


Power Pivot Principles: SWITCH with an Expression

29 September 2020

Welcome back to the Power Pivot Principles blog. This week, we will talk about using the SWITCH function to return an Expression.


Monday Morning Mulling: September 2020 Challenge

28 September 2020

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