Power BI

Adobe Illustrator has been a tool in my dashboard design kit for quite a while. I’ve used it predominately for creating report assets such as icons, headers and backgrounds. I’ve also used it to create SVG visual elements such as the dice, turbine and scatter plot shapes and markers pictured below. But there’s another way… Continue reading Power BI + Adobe = Magic

I had a business requirement where I needed to create a P&L report that included RLS by business leaders for each department. A leader…

We talk about Incremental Refresh a lot, but what if you need custom partitions in Power BI? How do you even create those? They look scary! Patrick takes the mystery away and walks you through how you can create them. Partitions in tabular models https://docs.microsoft.com/analysis-services/tabular-models/partitions-ssas-tabular

In a previous blog, I showed that dual Mode is really a very good pattern when building PowerBI Model that uses Direct Query, but it in order to work, both Tables needs to be using the same Data So…

Taking Lists from foe to friend. Lists in Power Query are something many people know nothing about. Power Query uses them all the time even though you may

Paginated Reports have been available in Power BI since 2019.  They serve an important purpose, but they are not easy for the average business user to learn, plus they require Power BI Premium to use.  In my blog and video today, I will show you how you can use Excel [...]Read More »

Recently, we hosted Allision Kennedy on the Raw Data by P3 Adaptive Podcast. During the course of the conversation, our co-host Thomas LaRock expressed

A Gantt chart is an excellent example of where Paginated Report & SSRS were an ideal choice for the purpose. It is a running list of activities with the duration for each displayed as a horizo…

In this blog post I will be sharing a PowerShell script that allows multiple Power BI reports to be downloaded at once. In the Power BI service, there is no way of downloading multiple Power BI reports at once. Therefore, users must download files one by one which is slow, time consuming and inefficient. Thankfully,

In Power BI there’s a popular custom visual called “Filter by list” that lets you filter a Power BI report by any list of values that you paste into it. It can save you a lot of t…

Learn how to create Ordinal Numbers in DAX and M. These numbers describe the position of something, such as 1st, 2nd, 3rd.

I’ve said it before but I’ll say it again: I don’t publish book reviews here on my blog but I’m always happy to promote new Power BI books when they are published in return …

One of the reasons I love using the Excel cube functions to get Power BI data into Excel instead of PivotTables is because they make it much easier to use other native Excel features and functions …

In the first post in this series I showed a simple example of how you can use the FORECAST.ETS function in Excel in combination with the Excel cube functions to do forecasting with Power BI data. I…

In this article, we will discuss how to deal with some common problems when creating reports based on employee attendance sheets. Next, let's take a closer look at the below scenarios. Scenario 1: Clean and extract valid records from attendance sheets Invalid or repeated employee punching behavior ...

Scenario: We usually hear words like words context, filter context when creating measure. Moreover, we can often see it on the DAX Guide website. But what is that? And how can we modify it? What is filter context? The reason why we sometimes cannot get the ideal result when we use a measure with sa...

Use Case - Sometimes there will be a need to extract domain names from given URLs. Hence http://www.microsoft.com should give microsoft. Below are some sample cases and the results expected.   Exclusion - Subdomains are excluded from the scope of this. Hence, https://powerbi.microsoft.com which has...

How do you learn a new skill? How do you go from beginner to intermediate to expert… or at least from knowing very little to knowing enough that other people start to think of you as an exper…

Video by: Reid Havens Learn how to add borders to object groups without using any additional objects or having to customize the page background ! This optimized technique insures that there is zero performance cost when loading the report page! RELATED CONTENT 🔗 Button Shadow

Welcome to the April 2022 update. We are excited to announce New format pane and Power BI Goals updates, tooltips drill actions support for more build-in visuals, error bars for clustered column and bar charts preview feature, general availability of Dynamic M query parameters. There is more to explore, please continue to read on.

We recently discussed an issue related to the Dictionary size reported by Bravo for Power BI that, in reality, references the behavior of VertiPaq Analyzer,

Join Bernat Agulló and I as he shows you how to level up your skills in Tabular Editor ! He'll spend time showing you how to use C# scripts and macros to create calculation groups , diagnose and optimize your model , and much more! Plus learn how to leverage Visual Studio to cr

In this session, Daniel will introduce you to the Vega-Lite language via Deneb - a custom visual for Power BI.

The ability to create a composite model on top of a Power BI dataset or an Azure Analysis Services model is in preview since December 2020. Since then, we have seen great adoption of this feature and have received great feedback that allowed us to make it even better! The team has been hard at work readying the feature for general availability, and although we are not announcing that today, we have great news to share regarding permissions.

We’re excited to announce the public release of new thin report capabilities for Power BI Documenter. According to early users, these new capabilities are helping to reduce the time spen…