News & Tips

In this article, you will learn how to quickly create and edit the formatting of Power BI combo charts. Combo charts are dual-axis charts (they have a secondary Y-axis), making them great ways to compare two different datasets against another…

The Group By feature in Power BI summarises data based on one or more aggregate functions.  You can use the Group By feature to find the average, count, min, max, or any other aggregate value for one column, based on…

In this article, we will look at how to create a Word Cloud with Microsoft Power BI. We will see what a word cloud is, why it is useful, and how to perform various transformations on a Word Cloud. If…

In this article, you will see how the Power BI Date format works and how you can format dates in the Power BI reports view as well as in the Power Query editor.   You will also use the different methods…

A Workspace is a place where you can work with your team, creating dashboards, datasets, dataflows and reports. Initially you will have access to your own personal workspace, called My Workspace, this enables you to work with your own content,…

The calculate function in DAX is one of the most widely used DAX functions. It can both be very useful on its own and also be used as a container for far more complex calculations because it can modify the…

This article explains what a Power BI hierarchy slicer visual is and how you can use it to filter information on various report types.  The article also describes some basic formatting options for the Power BI Hierarchy Slicer.  We cover…

The Replace function in DAX is a Power BI text function that you use to replace part of a text string with a different text string. It is relatively straightforward to use and appropriate for DAX beginners to be using.…

Waiting for Power BI if it is running slowly can be incredibly frustrating.  The bad news is that if your Power BI report is slow on the Power BI desktop, it will be even slower when you publish it on…

Templates are critical to increasing your work speed as you become a more advanced Power BI user. This article walks you through what they are and how to use them in detail with the help of an example. Templates are…

Microsoft recently (16th November 2021) announced that they have beta released a Google sheets connector for Power BI and Power Query.  This means that you can now connect to and import your business data from Google Sheets into Power BI…