Power BI

How would you call going from 380 tables in 18 Excel sheets, to one table on a single report page in Power BI?! Magic? Miracle? Check how Calculation Groups can help you to achieve (im)possible!

Hybrid Tables are an incredibly powerful feature in Power BI. But what if you wanted to create them outside of Power BI Desktop? Patrick shows you how you can do just that in Tabular Editor! –This Year let Source = Sql.Databases(“servername”), AdventureWorksDW = Source{[Name=”databasename”]}[Data], internetsales = AdventureWorksDW{[Schema=”dbo”,Item=”pbi_InternetSales”]}[Data], thisyear = Table.SelectRows(internetsales, each Date.IsInCurrentYear([OrderDate])) in thisyear –Last […]

If you are looking for the conditional formatting in the new #PowerBI formatting pane, I show you where to find it!

Switch Power BI chart axis dimensions to get data grouped by dates, weeks, months, or any other way that you want.

Microsoft Teams connector in Power Automate has actions which can send a simple text message or Adaptive card as a flow bot in a Teams channel. Messages or cards are posted as the user who’s signed…

How many ways there are to create a Year-Month column in DAX? In this blog post, I'll show you one bad way, one OK way, one good, and one great way.

Here we’ll lay out a common framework (which we’ll refer to as “C-Frame”) for managing Power Platform solution development. This approach is best suited for solutions that classify as important or critical according to the Environmental Architecture Model found in the Power Platform Adoption Framewo

This article describes the IN operator in DAX, which simplifies logical conditions checking whether a certain value belongs to a list of values. The IN oper

Today’s blog is a kind of continuation of my previous blog. However, there is no sequence to it so you can always enjoy reading it after this blog. Let’s think about Apps differently would be more …

In our earlier blog, we saw how to create a simple & basic Power App. In this blog, I will share some tips on enhancing some of the features. We will cover the below features today – Name the l…

Get latest copy of record from data source in Power Apps Canvas apps, Refresh a record in Power Apps Canvas Apps

Creating a custom theme for your Power Apps project is important. The colors, fonts, icons & control styles all contribute to a unique design

It is a quick Hack and maybe useful, let’s say you want to keep a snapshot of a previous data, for example you have a dimension table and you want to see how the data has changed between mult…

Here is how to calculate weighted average using DAX in Power BI. By using that, you can get results by necessary category.

At the end of last year two new, fairly minor, improvements were made to Excel VBA’s support for Power Query: you can now refresh and delete individual Power Query queries. These methods are …

One of the questions that I’ve been asked consistently over the past...

This simple application is a lightweight MVP Application Development Check List for Governance & Compliance. Track unlimited applications. I created check lists as templates, so you can reuse them in any applications. Simply create your checklists, add as many tasks to each checklist as you like. As...

A Center of Excellence can be tool or topic-specific. In this blog, we apply a CoE framework to focus on Power BI and collaboration in an organization.

OData has been adopted by many software solutions and has been around for many years. Most solutions are using the OData is to serve their transactional processes. But as we know, Power BI is an analytical solution that can fetch hundreds of thousands (or millions) rows of data in a single table. So, obviously, OData … Continue reading Optimising OData Refresh Performance in Power Query for Power BI and Excel

My go to progress dashboard calculates a lot of progress % metrics and graphs. However for larger projects, its often difficult to zoom into the graph. This is exactly why slicers exist

Few ways to get relative & abolsute refresh durations in Power BI

Our Power BI Principal Consultant Kane Snyder shares some tips and techniques on how to combine static and dynamic filters in a slicer

The latest updates to the Tenant-level analytics include interactive controls that make it a snap to identify stale and orphaned Power Apps deployed across multiple environments or the entire tenant.

This post explains how to build a multiple measure selector in chart, so that only part of the measures are displayed. A calculation group makes it possible.

Discover how Microsoft created new training methods on analyzing data with Microsoft Power BI to help them make data-driven decisions.

The concept of extended tables is at the core of the query performance of Power BI datasets, but it is often overlooked. This article will hopefully change this.