Please note javascript is required for full website functionality.

Blog

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.


Final Friday Fix: September 2020 Challenge

25 September 2020

On the final Friday of each month, we’re going to set an Excel / Power BI challenge for you to puzzle over so that you can get your “Excel fix”. Challenge your office colleagues to see who can solve the puzzle quickest. There are no prizes at this stage: you’re playing for bragging rights only!


Newsletter