Power BI

Tutorial: Create a decomposition tree visualization in Power BI

This blog post shows how you can safely transform column types in Power Query, accounting for columns that can possibly be missing.

Yesterday, I published a post about having a slicer that filters the rows in a table visual in Power BI that contains the characters from that slicer. A friend asked me what if we want to search for the first few characters? that means selecting the first character, then seeing all the possible second characters,…

Daniel Otykier the creator Tabular Editor walks us through his amazing Tool. Learn how to use Tabular Editor to increase your Model Development speed.

Power Apps April updates are now available, adding new capabilities for our makers, a new converged mobile player and usability improvements for the unified interface.

Since the incremental refresh is already available with a Pro license, it was time for me to deal with this topic. In the Power BI community, I found out that the known documentation describes how to set up an incremental refresh, but the examples are always based on a single query. In practice, how...

<p>Grids in unified interface have intuitive and intelligent column filtering options that help you refine your data quickly and gain insights. Slicing your data with an Excel-like experience helps you be more productive and serves you a powerful tool to create filters that can be used for one-off filters or to create personal views.</p>

<p>Power Apps mobile app now has all your apps. With the new Power Apps mobile app, you have access to both canvas and model-driven apps in a single view. Easily sort and filter your model-driven apps for quick access and pin model-driven apps to device’s home screen for native app like experience. Model-driven apps have a new, delightful experience, tailored for mobile scenarios. </p>

Here are seven tried-and-true tips from other successful Business intelligence adoptions you can’t miss.

Blogging about Power BI, Power Platform and other things I find interesting.

Monkey Tools is an Excel add-in that provides tools that help you build better Excel based models more quickly, and audit those you receive from others.

MonkeyTools Pro is a set of tools to help you build better data models more quickly and using data modelling best practices. They also help you audit what has been done in your data model.

Last week I got an email from one of our readers, with some feedback related to how Monkey Tools’ PivotSleuth works with Measure tables in Power Pivot.

A very quick performance tip: do you have users consuming Power BI reports with Internet Explorer 11 and an older Windows OS like Windows 8.1 or Windows 7? If so, their reports are likely to be slo…

For a solution I’m currently working on, I needed to get a list of all the tables of my solution with some information (name, position and type) of their respective columns. The goal was to e…

In a recent project, I was facing a really weird JSON structure. Each element of the JSON was more or less a dictionary with sparse keys. It means that the field names were different from an elemen…

I’m currently working on the setup of a data quality dashboard and Power BI was our natural choice to display valuable information. For an advanced use-case, we needed to consume CSV files co…

This blog post is the second of a series related to parsing time series about COVID-19, you can find the first one here. When dealing with time series, you should always check if your time series a…

Doubling times are an indicator to measure the growth rate in exponentially growing scenarios. Learn how to calculate them in DAX for display in Power BI.

This article describes how to compute visual totals accurately, in case a measure does not provide the right result at the total level but works correctly i

If you ever spend time looking at DAX generated by the Power BI Desktop Performance Analyser, you may notice a function called KEEPFILTERS appear from time to time. It’s not a function I find…

The new hierarchy slicer allows for data to be sliced based on different levels. This will reduce the number of slicers required on a report page.

Lately, I published the first out of two blogs about monitoring your on-premises data gateway. The first blog was all about monitoring your gateway up time but doesn’t tell you when one of th…

I was working on a project a wee bit ago that the customer had conditional formatting requirement on a Column Chart.They wanted to format the columns in the chart conditionally based on the average value based on the level of hierarchy you are at.Here is the scenario, I have a Calendar hierarchy as below: Calendar … Continue reading Highlighting Below Avg Sales per Hierarchy Level with SWITCH() and ISINSCOPE() DAX Functions in Power BI

The Pareto chart or diagram analyzes the frequency of problems or causes in a process. Learn about the other 7 Basic Quality Tools at ASQ.org.