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

Unlock the Power of Geo Data

Geo data, or geospatial data, is data that describes the location and attributes of objects or phenomena on Earth. This data can be used to create maps, analyse spatial patterns and trends, and model the real world. Geo data dashboards can also help organisations gain deeper insights into their customers, markets, operations, and performance. In […]

When to transform data

As a general principle we should always look to transform data close to its source to gain efficiencies and minimise potential for discrepancies Over the last few weeks we have shown how data can be combined from multiple sources in three different ways UNION in SQL APPEND data in Power Query UNION in DAX A […]

Steamlining Success with Payroll Automation

Are you looking for a payroll automation solution? Are you tired of your business spending hours manually calculating your payroll? Do errors occur every month as you process your overtime? Do you wish there was a better way to streamline your payroll process? Many businesses face challenges of managing complex payroll processes in a fast […]

Power BI KPIs

Power BI KPIs – an overview Power BI KPIs can be a very powerful way to draw attention to specific key performance indicators What is a KPI? a KPI (Key Performance Indicator) is a way to measure performance against a target. These targets can be financial, strategic, operational or simply functional. The important point is […]

Direction of travel on a map in Power BI

Can we show the Direction of travel on a map in Power BI? A global commodity trading client of ours had a requirement to create a dashboard that presented the latest locations and headings for a range of container ships This was part of a migration away from using Tableau, to using Power BI […]

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 […]

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 This guide shows you how you can set it up If you use the standard top N filter you would see something […]