Power BI

In this blog post, I'm sharing a technique to display text as values in a multi-row card and still have the special Card Title.

If you’re new to Power BI or consider yourself more experienced this reference sheet is for you. I collected all the MSFT Power BI links I feel are the most relevant to help you get ‘on your feet’. Feel free to print or bookmark this as a quick reference. I created this table for my […]

The drill through functionality is in Power BI for a long time and already made huge steps forward. Though, one of the most challenging things with this very valuable feature was the discoverabilit…

Grouping Basics You can find the Group By button on the Power BI Query Editor window in 2 places: In the result dialog box, you can choose your key columns and aggregates. The key columns will default to what columns you currently have selected: From here, you will get the grouped result: Custom...

COALESCE is a DAX function introduced in March 2020. This article describes the purpose of COALESCE and how to simplify DAX expressions by removing verbose

In the previous article/video, I explained how to create dynamic bins by choosing the count of bins in a slicer in the Power BI report. In this article, I'll explain, how you can do it the other way around, which is by selecting the size of the bin, you will have bins and buckets dynamically…

Banding (or binning or grouping) is a scenario that can be implemented both statically and dynamically in Power BI. Dynamic banding means selecting the bin (or band) configuration, and the banding changes based on the user selection of the slicer. Imagine that we have a count of customers by their age groups, but then we…

One of the most common types of banding or binning is banding based on a range. Let's say, for example, you want to have a group of customers based on their age group. The age group banding can be created in Power Query at the data transformation stage. It can be created using the Grouping…

This will show you how to use a DateKey or Date column to incrementally refresh your Power BI dataset which improves refresh performance

9 PowerBI tips to help you manage and perfect your PowerBI, DAX and analysis skills.

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

We have great updates this month! We are releasing new button actions, multi-column sort for tables, dual axis for line chart, a search for the filter pane, updates to decomposition tree, and much more! We are also releasing a preview of an enhanced dataset metadata feature, which will be foundational for XMLA read/write and for management of Power BI dataset and the migration of Analysis Services workloads to Power BI. Check out the full blog to learn more about all the updates and enhancements this month.

Explore the options when implementing Row Level Security in your tabular model.

Today, I’m excited to announce that we’re releasing a new, revamped search experience that allows users to search across all the content they have access to from any page in the product!

Showing how the use of the Aprrox Distinct Count is a lot faster than using the DISTINCTCOUNT that is native to DAX measures.

A common topic I have been discussing recently with customers is the security around Power BI. Basically, how to prevent users seeing data they shouldn’t. So I’ll discuss the various &#…

Power BI includes a very rich set of data connectors to get your data from. Both connectors to on-premises and cloud solutions are provided which sometimes require an On-premises data gateway in or…

Quick note to the Power BI developers looking to up their DAX game… I’ll be presenting a new session – Power BI Time-Intelligence: Beyond the Basics – to the following user …

My goal with this template app is to make responsive design a little easier. I have spent an extensive amount of time designing responsive apps and

We are thrilled to announce an additional layer of capabilities, allowing you to export a Power BI report by using a REST call, to the following file formats: PDF, PPTX (PowerPoint) and PNG. 

Reading Time: 4 minutes Power BI buttons provide more interactivity in reports, and different states allow unique formatting when users interact with a button. What are the visual icons available when using buttons in Power BI, and is it possible to extend them? Button Icons Power BI has a handful of button icons that provide cues for user interactions.…

Much has been said about DAX, and even more will be told, as DAX still evolves and the adoption of tools that are using DAX like Power BI and MSFT Analysis Services Tabular is growing. This series of blog posts are inspired by questions asked on https://community.powerbi.com. These questions are touching the most foundational concepts and are reminding me of my journey into the realm of evaluation context, filter propagation, data lineage, the scope of variables, and the mysterious world of table iterators, just to name some concepts. Sometimes it seems that these foundational concepts are ...

Introducing Interactions Setting, which lets you configure how to interact with reports in Power BI mobile apps. Including docking report footer and enabling multi-select!

This article discusses how to scrape data from dynamic websites that reveal tabulated data through a JavaScript instance.

Okay, the title of this blog post could also have been "SUMX returns unexpected results with duplicates". The results only seem incorrect because an incorrect assumption might have been made. Let's dive into the issue with an example. The Problem Suppose we have employees entering timesheet da