Power BI

Get faster app load and edit times for canvas power apps when you switch to new analysis engine. Complex apps should see a significant performance boost.

A summary of product, community, and learning updates from throughout the month so you can access it in one easy place. This month we're excited to share Copilot updates, GA of some key features for our makers and a huge set of Learning and Documentation updates.

We are excited to announce you can now write DAX queries with DAX query view for web from published semantic models in the workspace.

Normalizing conditional formatting bars in Power BI is not easy, but can be done with a measure and a calculation group. No more bars covering the values.

There are different approaches to having a dynamic axis in Power BI. Adam walks you thought 3 way to accomplish it within your Power BI report. Patrick’s Dynamic Axis video: https://www.youtube.com/watch?v=n-OWNaCUU0o Kasper’s Blog: https://www.kasperonbi.com/dynamically-switching-axis-on-visuals-with-power-bi/ Patrick’s Personalize Visual video: https://www.youtube.com/watch?v=20HwiEhIShc Buttons & Bookmark playlist

In this lab we will be implementing a forecasting measure using DAX. We will not be generating a forecast data set, rather, we will create a measure that will look at the actuals from the past to f…

Last week I was honoured to take part in the latest edition of the Power BI Dev Camp which is run by my colleague Ted Patterson. It was a fun session which I enjoyed. As part of...

I have decided to spend some more time on Market Basket Analysis, but before I get into the storytelling part of it, I had to clean up and fix a few things in the model file for the Market Basket A…

I have to warn you, this is NOT a level 100 or even 200 tutorial. If you decided to proceed, that you absolutely positively have to get that progressive calculation work and I will have to assume t…

I use Sales data a lot in my tutorials and usually the Sales Fact table will have the following fields in it: DateProductRevenueUnits Along with a bunch of other stuff…. Now, it is actually very co…

I show how you can use Vertipaq Analyzer with your Power BI Model to understand what is consuming memory and how to solve it.

Last week I was honoured to take part in the latest edition of the Power BI Dev Camp which is run by my colleague Ted Patterson. It was a fun session which I enjoyed. As part of the Dev camp, I wal…

DAX Power BI Visual Studio Code External Tool

In this article, I’m going to show how you can use Visual Studio Code to run queries against a Power BI model. Usually, this is the kind of task you would use the excellent DAX Studio for, bu…

I often get this question: "Is it better that I create this calculation as a snapshot table in Power Query (or T-SQL, or the data source), or write DAX measures for it?" If you ever had a scenario of creating a report of snapshots, you know what I mean. "Should I have a table for…

In one of my last tutorials here, we learned how to apply time-intelligence in DAX to analyze the COVID-19 data that is provided by Johns Hopkins University. The focus so far was to provide correct calculations on a daily level or to smooth them using running averages here. In today's quick tutorial, you will learn…

Using Calculation Groups to show currency formatting strings which will display the currency sign in Power BI or Analysis Services

This article describes how to use conditional formatting with a DAX expression to color the rows of a table in Power BI based on the order number instead of

This article describes how to use conditional formatting with a DAX expression to color the rows of a table in Power BI based on the order number instead of

In my last tutorial here, you learned how to import COVID-19 confirmed and death cases from Johns Hopkins dataset to build your own Power BI dashboard using Power Query. In this tutorial, we will go quickly through the DAX measures that will help you gain better analytics capabilities using Power BI time intelligence. To follow …

Learn to configure your Power BI Aggregations table to really increase the speed of your DAX queries. This does NOT require Power BI Premium!

A question I come across in Power BI from time to time is how to configure a report to show an end-user a list of options, and then have visuals in the report use the selected item on the axis. The…

A few months ago, a very interesting question was posted on the Power BI community forum and I had the opportunity to work on it. Finally, I have the time to write a blog post about this so that we…

I came across an interesting request last week from someone who wanted to dynamically control columns shown in a Power BI table visual – based on the values within each table. There are lots …

A question I’ve received a couple of times recently is how to override slicer selections in Power BI visuals. Or more specifically, if the user selects a specific item in a slicer (or filter)…

Multiple patterns on how to tackle things with DAX vs with Power Query in terms of column creation and which approach is the most optimal.

Different modeling approaches can speed up performance of your Power BI dataset - albeit with the tradeoff of additional complexity. One situation is where users need to access a very large dataset, but typically apply the same set of filters - resulting in a small subset of rows meeting the needs of most queries. A sliced aggregate approach (implemented in the data model + DAX) can be used to make your models performant where they need to be, but still allow the full range of reporting.

Workarounds…..workarounds…..workarounds. We all build workarounds as necessary until more enterprise-ready functionality is made available. This is true for Power BI Usage metrics across workspaces. We have usage models for each individual workspace but there are several issues with them. you have to copy the model in order to edit it and make it useful you […]

Did you know, Analysis Services (the engine behind Power BI) keeps track of the number of referential integrity (RI) issues in your model? It uses this information to decide if some calculations ca…

If you’re building DAX queries using Power BI Report Builder you might notice something that looks like a new DAX function called RSCustomDaxFilter. For example, here’s a simple DAX query built fro…