Power BI

Environment Canterbury (ECan), a part of local government for the Canterbury region in New Zealand, partnered with Datacom Systems to deploy a Power Platform solution that provides a more consistent approach to how all freshwater and natural resources projects are managed and reported on. The solution has served as a proof point for moving ECan from older paper and Excel-based processes into new ways of working with digital technologies.

College Scorecard makes it easier for students to search for a college that is a good fit for them. They can use the College Scorecard to find out more about a college's affordability and value so they can make more informed decisions about which college to attend. Source: U.S. Department of Educ...

When creating a budgeting prediction, most of the time we are creating it on the higher granularities. Rarely we do it on a daily basis.But sometimes we are required to match budgets to actual sales o…

Level: Intermediate Pareto Analysis is a statistical technique that applies the Pareto Principle to data. This is more commonly known as the 80:20 Rule. The Pareto Principle is based on the presump…

In Power BI, report authors can use themes in reports to keep the color palette consistent across visualizations. Let’s look at how to use themes. Below is a pretty simple report. Note in the navigati…

This article explains how calculation items are applied to measure references, and it is part of a series dedicated to calculation groups in DAX. Before sta

Time and time again when I begin talking with Excel users and ask to see what current reports they are using, they usually show me [...]

<p>Automate your Application Lifecycle Management with PowerApps Build Tasks for Azure DevOps</p>

The problem of blank values being shown in a Power BI slicer is fairly well known, but did you know that in some circumstances slicers can show other values that you would not expect to see? While the…

I was recently tasked with creating a cross sales report. This report aims to capture the product penetration across our customer base. I created the report in Power BI, leveraging Power Query to ensu…

You've got a default environment, and other ones. What's that all about? Well to understand it, we need to take a look at the Common Data Service

Learn how to create powerapps navigation menu using gallery control in Microsoft PowerApps.Step by step tutorial on how to create powerapps navigation using gallery control.

Do you have a lot of measures in your Power BI desktop file and don't know which are not used anywhere? I'll show you how to find them.ower BI Desktop file.

In this quick post I will walk through adding a data refresh date on a report page in Power BI.

Here is a post that is long overdue as the functionality has been available for almost a year now. Today we will enable scheduled refresh to the Strava custom connector...

Business intelligence and advanced analytics both make intensive use of Data Visualization. However, the use of visual communication is different in key aspects.

This blog post shows how to use a DAX measure with adding in line breaks with Power BI which makes for easier reading of filters

This outlines the new features for July gateway release.

Ever struggled with a formula in DAX that does not compute what you want? It has happened to us many times, and we know that the problem is ALWAYS related t

Announcing support for sending refresh failure notifications to others in addition to the dataset owner. This feature enables dataset owners to monitor data refreshes more reliably and more e…

You probably know that you can trigger an associated Flow from a PowerApp. You didn’t? Well you know now! But did you know that PowerApps and Flow can work in perfect harmony after configuring your PowerApp and Flow correctly? In this blog, I will explain you how to achieve this. By default, there isn’t much […]

This post shows how to create your own JSON object from csv or tab delimited. This is an extended solution to my other solutions on handling csv and tab delimited files. It will allow you to access the column names from the dynamic content. You can insert this solution into my other solutions at...

In Power BI Desktop, there is the option to display contents using a monospaced font, where each character has the same space. To do this, open your report and go to the Power Query Editor. Click the View tab, and you will see Monospaced: With this unchecked, we can see that our Id field is not aligned in our grid: On checking it, we can see that the field is … Continue reading Display Preview Contents using a Monospaced Font in Power BI

SUMPRODUCT is a very powerful formula for filtering criteria in both columns and rows. This post will show you how to use OR and AND criteria together.

I’ve had many people tell me that they have a blog so they will have a place to look to find the information that they need, and answers to their own future questions. This isn’t typica…

In this post I will be explaining how to use the JSON Function to simplify the saving of multiple pictures from a PowerApp to a SharePoint library using Flow. There have been many wonderful workarounds to do this, finally we now have a slightly less Heath-Robinson method.

Every respected computer scientist has heard about recursive functions (more details on Wiki: https://en.wikipedia.org/wiki/Recursion). There are many algorithms which are mentioned as example of such functions, i.e. Fibonacci sequence as the simplest example: Fib(0) = 0 Fib(1) = 1 For all integers ...

Here are links to the resources that helped a client recently as her team is switching over to Power BI. For additional resources, please let me know what you’d like to see, and I will dig it…

Did you know, in some cases, it is possible to add columns to your model to speed up the DAX used behind visuals to make them as much as 100 times faster? The PBIX helper file for this article can …