Category: Power BI

Power BI Blog

This page is a blog category page for Power BI. Which is a business intelligence tool that provides interactive visualizations and data insights.

The page shows the latest posts that are related to Power BI. This includes Power BI timesavers, tips, tricks, tutorials, and best practices. The posts are written by experts and enthusiasts who share their knowledge and experience with Power BI.

Our Most popular Power BI Blog posts

Some examples of the most popular blog post about Power BI are

Advanced Top N Power Bi filter: This post explains how to create a dynamic filter that shows the top N values of a measure. As well as the values of the whole. This is useful for comparing the performance of different categories or groups.
Custom Formats in Power BI: This post shows how to use custom formats to display numbers, dates, and text in Power BI. Custom formats can help to improve the readability and consistency of the data. As well as to add symbols, colours, or conditions.
Power BI drill though: This post demonstrates how to use the drill through feature in Power BI. Which allows the user to navigate from one report page to another, while passing a filter context. Drill through can help to create interactive and detailed reports that answer specific questions.
[How to add a date dimension in Power BI]: This post guides the user on how to easily add a date dimension table in Power BI.
A date dimension table contains one row per date, and various attributes and classifications that can be used for slicing and dicing the data.
[Top Power BI Tips for 2023]: This post highlights the top five Power BI tips for 2023. Based on popularity. The tips include how to show values in rows in the matrix visual, how to use the TOPN function, how to toggle measures, how to create rolling averages and sums, and how to unlock the power of geo data.

Other Blog Categories

You may also be interested in our DAX category page which features blog posts which go into more detail around the data analysis expressions language used in Power BI

DAX Archives – Select Distinct

or for more general business analytics blog posts simply refer to our business analytics blog

Business Analytics Blog – Select Distinct

BambooHR integration to Power BI

BambooHR integration to Power BI to get real time visibility of your HR data On a recent project a client had a requirement to connect BambooHR to Power BI. This focussed on BambooHR UK but the system is used worldwide. This blog seeks to share some of the steps and experience. These methods will no […]

UNION in DAX

Using UNION in DAX is a third option to combine data for analysis in Power BI We recently showed how to do this in SQL UNION in SQL and how to do similar in Power Query APPEND in Power Query It isn’t always possible to do this in SQL such as if the datasets are […]

How to APPEND data in Power Query

Last week we looked at how to combine datasets in SQL using UNION UNION in SQL – Select Distinct This week, we are looking at using the same source data, but doing the combining in Power Query, via the transform options in Power BI It is not always possible to combine the data SQL, particularly […]

Connect Power BI to Google Big Query

A Quick Guide to Connecting Power BI to BigQuery Power BI is a leading business intelligence platform, with powerful features for self service analysis BigQuery is a fully managed cloud based data warehouse platform for you to manage your data The great thing about both of these platforms is that they both have a really […]

Advanced Top N Filter Power BI

The basic Top N filter in Power BI can be very useful. But if you need to show the values of the whole you will need to use an advanced Top N Filter Measure This guide shows you how you can set it up If you use the standard top N filter you would see […]

How to use Custom Formats in Power BI

Custom Formats in Power BI allow you to create your own specific formats so that you are not limited to the pre-defined options that come as defaults Some organisations have specific standards for things such as date formats, these can be catered for using custom formats For example if you want your date formats to […]

TOP N in Power BI

Understanding TOP N in Power BI You have heard of the 80:20 rule (Pareto)? In the world of data analysis, having the ability to efficiently rank and prioritize information is crucial. This is where the TOP N function in Power BI comes into play. By utilizing this powerful ranking function, analysts and data professionals can […]

SAMEPERIODLASTYEAR in Power BI

How to Use SAMEPERIODLASTYEAR in Power BI SAMEPERIODLASTYEAR in Power BI is great way to simplify the analysis of year over year performance One of the most common tasks in data analysis is to compare the performance of a business or a process over time. For example, you might want to see how your sales […]

Power BI Drill Through

Understanding Drill Through in Power BI and How to Use it to Dig Deeper into Your Data Introduction: What is a Drill Through in Power BI and What Does It Do? Drill Through in Power BI is a powerful feature that allows users to explore their data in greater depth. It enables users to drill […]

Toggle Measures in Power BI

Space on your dashboards is a limiting factor To make the best use of limited space setting up toggle measures in Power BI helps to use the space better One of the key challenges with dashboard building is finding the balance between detail and available space This article shows you how to combine a couple […]