Please note javascript is required for full website functionality.

Blog

Power BI Blog: Conditionally Formatting Brackets with Negatives

25 June 2020

Welcome back to this week’s edition of the Power BI blog series. This week, we look at how to apply conditional formatting – specifically including brackets – to negative field values.


Power Query: Mind the Large Overlap

24 June 2020

Welcome to our Power Query blog. This week, I look at a more efficient method to spot overlapping periods.


Power Pivot Principles: Introducing the VALUES Function

23 June 2020

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


Charts and Dashboards: Hiding Data - Part 2

19 June 2020

Welcome back to this week’s Charts and Dashboards blog series. This week, we’ll continue to talk about how to hide chart data.


Power BI Blog: Conditionally Formatting from Text

18 June 2020

Welcome back to this week’s edition of the Power BI blog series. This week, we look at how to apply conditional formatting to field values, based upon rules derived from text.


Power Query: Mind the Overlap

17 June 2020

Welcome to our Power Query blog. This week, I look at a method to spot overlapping periods.


Power Pivot Principles: DISTINCT vs. DISTINCTCOUNT

16 June 2020

Welcome back to the Power Pivot Principles blog. This week, we will consider the differences between the DISTINCT and DISTINCTCOUNT functions in DAX.


A to Z of Excel Functions: The IMABS Function

15 June 2020

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


Charts and Dashboards: Hiding Data - Part 1

12 June 2020

Welcome back to this week’s Charts and Dashboards blog series. This week, let’s talk about how we can hide one or more data points in a chart.


Power BI Blog: Conditionally Formatting Negative Numbers

11 June 2020

Welcome back to this week’s edition of the Power BI blog series. This week, we take a look at how to apply conditional formatting to negative numbers.


Newsletter