Power BI

learn how to use TopN function in DAX either to create a calculated table, or to use it in a measure to achieve analysis such as; comparison with the average amount of the top group.

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

Part 2, goes into comparing the scalability between AAS and PPU and how it compares to when it is scaling upwards.

We’ve just finished a difficult yet fulfilling 12th round for the Power BI Challenge, which was based on a transport and shipping dataset. This was probably one of the most difficult challenges we’ve had to date, and we’re very impressed with the participants’ in-depth analysis on their entries.    ...

Month by month I keep updating the Blog Portfolio of powerBImap.com: And each time I think this time we covered most of them, the next update will be a small

Recently Microsoft announced the Power BI integration with Jupyter, Now we can tell data stories using Jupyter notebook.As Microsoft launching new powerbiclient package we can export and embed Power …

Last year at Build 2020, we debuted the Microsoft Teams Toolkit for Visual Studio Code and Visual Studio – extensions that streamlined the app development process within the tools developers already knew and loved. Now, a year later at Build 2021, we’re continuing that momentum by sharing a major up...

This is the third article where I have covered building a P&L in Power BI. My first 2 articles here and here focused on how to use the DAX language to solve some of the common problems with P&L reporting, such as adding sub totals into the visual, % of [...]Read More »

Exam Ref DA-100: Analyzing Data with Microsoft Power BI is available now! Direct from Microsoft, this Exam Ref is the official study guide for Exam DA-100.

Wow – just wow. Thank YOU my dear readers for making my little blog page that huge ;-) More than happy I found out yesterday, that this page – is now featured in both – the BARC P…

According to the internet, a maxim is a succinct formulation of a fundamental principle, general truth, or rule of conduct.[1] Maxims tend to relate to common situations and topics that are underst…

Part of the the series: Doing Power BI the Right Way Later in this post, you will find a 27 minute framed video including a series of interviews and discussions with a few of my colleagues. Th…

Scenario:     In this scenario, the column [City] in my table has some dirty data with some space and case errors. It's also a mixture of abbreviations and full names of the cities. I want to find a way to unify the value of the column ‘City’ into the abbreviation of the cities, and merge this abbr...

We’re excited to bring you a new version of Power BI Report Server this month! With this update, we have a ton of enhancements, including a new field list, new and improved shape options, and several visual formatting features.

learn how to document your entire Power BI file in a few clicks, including all measures, codes, visualization, all for free and simple to do.

Enterprise Service Management (ESM) Performance Dashboard built on Microsoft Power BI for the BMC Helix Remedyforce platform

There were several interesting Data & AI announcements that came out of Microsoft Build 2021. I put together this summary of 11 interesting and includes links to both the announcements and other follow-on information.

Learn how to export the data of a Power BI table in a few clicks. Any size, any table format, can be exported for free to a CSV file easily.

Learn how to write calculations in Power BI for comparing values of a month with the month before and get variance and percentage.

This post reviews the deployment of common changes to Power BI datasets and the implications for the availability of the affected objects for users and reports. BI teams and owners of PBI datasets …

A few months ago I heard about a new tool from Microsoft called Lobe which makes it easy to train machine learning models. It’s nothing to do with Power BI but I find anything to do with self…

This article describes a very common optimization pattern that relies on variables to optimize conditional expressions in DAX. In a previous article we show

Back in December, we launched a new create experience within the Power BI service that allowed you to quick explore your data with just a few clicks. Now, we’re excited to announce, as our first integration of this experience, the launch of our Power BI integration within SharePoint lists. This experience empowers SharePoint list and Microsoft List users to easily explore their list data with just a few clicks.

Last month I wrote the first part of this blog post, which is intended for users that are in the beginning of their Power BI journey. After a long wait, I finally had some time to finish the second part of the post! If you don't remember what we discussed in the first post, have a look in the link below: Power BI Report Development 101 - Part 1 (datapears.com) Review of the Part 1 finished? Amazing!! So, let's go back to our diagram: Colours legend: Blue Squares - These steps are usually mandato

We’ve started to roll-out an update to the home experience in the Power BI app for Microsoft Teams. Users in Teams will see a new “In Teams” pivot on Power BI home that makes it easy to find Power BI tabs you’ve visited previously in Teams channels. Read the blog to learn all about it.

I'm going to start this post by saying that it will be a bit different from the posts I've written before. Today, I will be sharing with you my ideas around core Power BI skills, and how I see them …

If you want to show the ranking in a Power BI visual, one way is to use a visual that supports that, such as a Ribbon chart. Another way, which is a more common way, is to write a calculation for rank, and RANKX is a DAX function that can help you with that. In Read more about Showing Ranking in a Visual in Power BI using RANKX DAX function[…]

Microsoft Excel is one of the most common data sources for Power BI. We can store Excel files in various storage types. The way we get data from Excel varies depending on the storage type. In this post, I quickly show two methods to connect to an Excel file stored in SharePoint Online. Method 1: … Continue reading Quick Tips: Connecting to Excel Files Stored in SharePoint Online from Power BI Desktop

Looking for ANOMALIES in Power BI? Justyna Lucznik walks Patrick through the new anomaly detection in Power BI and gives a SNEAK PEAK at what’s coming! Anomaly detection: https://docs.microsoft.com/power-bi/visuals/power-bi-visualization-anomaly-detection

Learn how a Center of Excellence helped Microsoft create a standardized analytics and data platform to unlock insights with the right operating model, stakeholder engagement, and shared and dedicated investments.