Power BI

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.

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

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...

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

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.

The importance of empathy in stimulating a data culture, one where others want to participate.

Tabular Editor is not only a helpful tool for developing DAX. You can also use it to view & modify your Power Query M code, without ever opening Power BI desktop . Furthermore, there also exists a formatter for Power Query that can help you make your code easier to read & manage. He

If you have a set of goals that you want to rollover into a new scorecard, or just want to bulk copy goals across scorecards, this utility script can save you some time by automating the copy process. What gets copied:    - Scorecard name, contact, and description (when duplicating scorecards)    -...

Inforiver launches the Premium Edition in Microsoft Appsource. Read more for the use cases on Premium edition's powerful capabilities.

A step by step guide to implement the Poisson Distribution in Power BI using DAX

In this post, I will describe what is the Pearson correlation coefficient and how to implement it in Power BI using DAX. What is Correlation Coefficient The correlation coefficient is a statistical measure of the relationship between two variables; the values range between -1 and 1. A correlation of -1 shows a perfect negative correlation, a correlation of 1 shows a perfect positive correlation. A correlation of 0.0 shows no linear relationship between the movement of the two variables. How to interpret...p class="read-more"a class="btn btn-default" href="https://datakuity.com/2021/10/29/correlation-coefficient-in-power-bi-using-dax/" Read Morespan class="screen-reader-text" Read More/span/a/p

List of the most comon Univariate Statistics DAX Cheatsheet available in Power BI with their DAX code

Hybrid Tables: Hybrid tables are large tables that have one or more partitions in Import mode and another partition in DirectQuery mode. This will make the refresh of huge tables faster with incremental refresh. Plus get the latest data in real time with DirectQuery.