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

Comparing Year on Year in Power BI

In an earlier post we showed you how to use SAMEPERIODLASTYEAR in power BI to compare data to the prior year The major shortfall of this is that the built in function matches the day of month and month, and does not properly reflect the day of the week If we show these with the […]

A Guide to Extracting Data from Joblogic

Following on from the blog last week I thought I’d write a similar guide to extracting data from Joblogic. Joblogic is a popular Field Service Management (FSM) software that helps facility management companies run their operations. FSM software is particularly useful for companies that provide services at the customer’s location. These companies are generally involved […]

How to Sync Slicers in Power BI

This post explains how to sync slicers in Power BI, without any complex code Slicers are an excellent way to give your users the ability to explore data, allowing users to use the slicers to filter the data down to particular information of interest. But, if your data has different data sets with common values […]

Using Google Search Console Data in Power BI

Google Search Console is a very powerful tool to measure SEO performance, this post highlights how with a little effort you can use Google Search Console Data in Power BI to create much more compelling dashboards It tracks a vast amount of really insightful data, but the reporting is limited The example below is the […]

Choosing the Right Paginated Reporting Tool

Pixel-Perfect Precision: In the data realm, the importance of robust reporting tools cannot be overstated. Businesses rely on accurate, timely, and insightful reports to drive strategic decisions, identify trends, and measure performance. In the modern landscape there is lots of focus on interactive visualisation software. However what are the options the distribution and delivering of […]

Navigating Power BI Data Alerts

Introduction Whilst reporting is a key component of any business, how do you respond to key changes. How do you ensure actions are generated when the data changes beyond the limits you set. As part of our Business Support Expert Services this was a problem we had to overcome. This blog aims to discuss the […]

The Microsoft Fabric Offering

Introduction Microsoft Fabric, the unified environment launched in 2023 is now central to Microsoft’s data strategy. What is the Microsoft Fabric Offering? What is Microsoft’s competition to this software? What other unified environments are available. This blog aims to demystify some of these areas. What is the Microsoft Fabric Offering? Microsoft Fabric brings together multiple […]

Top Power BI Tips for 2023

Here are our top Power BI tips for 2023 Highlighting our top 5 Power BI tips for 2023 based on popularity Our most popular Power BI tip this year Show values in Rows in Power BI How to show values in rows in the matrix visual in Power BI. a step-by-step guide to change […]

Calculated Columns and Measures in Power BI

Introduction to Calculated Columns and Measures in Power BI A guide to understanding the differences between calculated columns and measures in DAX for Power BI What is a calculated column? A calculated column is a static value added to a table, calculated row by row when you load the data. What is a measure? […]

Integrating Joblogic with Power BI

Introduction Our client provides nationwide engineering maintenance services. They use Joblogic, a comprehensive field service management software, to track activity. In this blog we talk about Integrating Joblogic with Power BI. Field Management Software Field service management software improves efficiency, productivity, and customer satisfaction of businesses. It helps them plan, schedule, invoice. Field service businesses, […]