Please note javascript is required for full website functionality.

Blog

Charts and Dashboards: Conditional Chart Labelling – Part 1

4 March 2022

Welcome back to our Charts and Dashboards blog series. This week, I take the first step towards creating conditional chart labels by producing multiple number formats.


Power BI Blog: Power BI Goals Updated

3 March 2022

This month, Power BI has seen updates on Teams notifications integration, plus the ability to add multiple owners to a goal and the ability to create scorecards in My Workspace. Additionally, Goals is now available in all US Government clouds.


Power Query: Too Random

2 March 2022

Welcome to our Power Query blog. This week, I look at another way of generating random data.


Power Pivot Principles: The A to Z of DAX Functions – ALLCROSSFILTERED

1 March 2022

In our long-established Power Pivot Principles articles, we continue our series on the A to Z of Data Analysis eXpression (DAX) functions. This week, we look at ALLCROSSFILTERED.


Monday Morning Mulling: February 2022 Challenge

28 February 2022

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: February 2022 Challenge

25 February 2022

On the final Friday of each month, we are 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 are playing for bragging rights only!


Power BI Blog: Parameter Typo

24 February 2022

Welcome back to this week’s edition of the Power BI blog series. This week, we look at an issue which can occur when using a parameter as a filter.


Power BI Blog: New Format Pane, Still in Preview, Now on by Default

24 February 2022

Well this has stuffed up our latest book – re-writes are underway!! It’s time to hunt everything out again: the new Format pane is now on by default for users upgrading to the latest release. Microsoft has added a notification dialog to call attention to this change.


Power Query: Totally Random

23 February 2022

Welcome to our Power Query blog. This week, I look at one way of generating random data.


Power Pivot Principles: The A to Z of DAX Functions – ACCRINTM

22 February 2022

In our long-established Power Pivot Principles articles, we continue our series on the A to Z of Data Analysis eXpression (DAX) functions. This week, we look at ACCRINTM.


Newsletter