Power BI

In this article we will show you a quick and easy way to group your data into ranges or bands in Power BI. This can be useful if you want to create visuals such as pie charts or bar charts and include the bands in these. Follow the two steps below to add banding to … Read more

In this article, we show you how to create a button to clear all filters with one click in Power BI. There are two methods to achieve this. The first method has been made available recently from a Power BI update and is a very simple way to add a button to clear all filters. … Read more

In this article, we will show you two methods of calculating the number of working days between two dates in Power BI. The first method is to use the NETWORKDAYS DAX function and a table to exclude public holidays. The second method uses a calendar table with your public holidays table and the DATESBETWEEN DAX … Read more

In this article, we will show you how can calculate the difference between two dates in Power BI using DAX. The DAX function we use to achieve this is DATEDIFF. This returns the difference between two date fields and can be expressed in days, weeks, months, seconds, and more. We go over different common questions … Read more

In this article, we will show you how to sort multiple columns in your Power BI tables. You can sort a column in any table by clicking the column header. This will sort the column in ascending order. If you click the column header again, it will sort the column in descending order. When you … Read more

In this article, we will show you two methods of how to sum multiple columns in Power BI. The first method uses a calculated column and the second method uses DAX functions. We will also cover common questions such as incorporating filters or combining columns from different tables in Power BI. How to sum multiple … Read more

When customizing the look of your Power BI reports, you may have wondered if you can change the background color of your visuals. This is especially important when you have changed your canvas color and want to make the backgrounds of your visuals transparent. In this article we will show you how to change the … Read more

In this tutorial, we show you two easy methods for calculating ages from dates of birth in Power BI: Calculating age from date of birth using Power Query Firstly we will show you how to calculate age from date of birth in Power Query. Here are some example dates of birth: If you want to … Read more