Power BI

Want to format a measure based on a slicer selection, the measure value, or another conditional way? Now you can! With dynamic format strings for measures a DAX expression can now be used to determine what format string a measure will use.

In this short article, I show you how to upgrade the compatibility level of models managed in Tabular Editor to be able to use new/preview features like Dynamic Format Strings.

Introduction Automated data storytelling is a powerful way to transform complex data visualizations into meaningful narratives. By leveraging OpenAI’s natural language generation capabilities…

data business intelligence bi machine learning mi professionals contractors azure Power bi analysis ETL ELT modeling automation training leadership

Automatic page background image in Power BI is not super easy because you need a theme file and a usable URL. This blog pots walks through the process.

Data preparation is crucial in data analysis and machine learning projects. This article will explore basic concepts and extensive details on the various aspects of data preparation.

In recent years, Power BI has become one of the most widely used business intelligence (BI) tools. Power BI is more than just a reporting tool; it is a comprehensive analytical platform that enables users to collaborate on data insights and share them internally and externally. In addition to creating reports and dashboards, Power BI … Continue reading Power BI Governance, What Organisations Need to Know

Pareto 80/20 calculation using WINDOW function in Power BI

I show you how you can modify or change your dynamic format string after you created it in Power BI desktop.

In today’s data-driven world, organizations need to harness the power of data analytics to make informed decisions, drive growth, and stay competitive. Microsoft offers two powerful tools for…

Working with many companies that implement Power BI, this is a question that comes along every single time; Should we enable workspace creation for all our users, or limit it to a specific security…

Welcome to the Power BI April 2023 Monthly Update! We are happy to announce that Power BI Desktop is fully supported on Azure Virtual Desktop (formerly Windows Virtual Desktop) and Windows 365. This month, we have updates to the Preview feature On-object that was announced last month and dynamic format strings for measures. We have additional features in Reporting, Data Connectivity, Service, Paginated Reports, Mobile, and Visualizations. Read on to explore all we have to offer this month!

Learn how to use custom format strings in Power BI Desktop to customize how fields appear in visuals.

SQL has been used to get data out of databases for decades. Dataverse is a database. So lets use SQL on Dataverse to fetch data into a report

Creating variables and collections is an essential part of the app building process. Therefore, we are excited to announce the general availability of an improved, seamless experience that enables makers to see variables and collections directly in-line with the canvas designer! Gone are the days of switching between the app designer and backstage to set…

A guide on how to send ChatGPT prompts inside Power Query scripts and save the data right back as new columns into your actual data.

Welcome to the Power BI April 2023 Monthly Update! We are happy to announce that Power BI Desktop is fully supported on Azure Virtual Desktop (formerly Windows Virtual Desktop) and Windows 365. This month, we have updates to the Preview feature On-object that was announced last month and dynamic format strings for measures. We have additional features in Reporting, Data Connectivity, Service, Paginated Reports, Mobile, and Visualizations. Read on to explore all we have to offer this month!

Introducing data model editing in the web! A first step towards modeling parity in the Service.

Contribute to PBI-David/Deneb-Showcase development by creating an account on GitHub

This article describes how to use the Group By Columns property to store the slicer selection by using the same column used in a SWITCH function to optimize

Since the first chief data officer was appointed at Capital One in 2002, the role has been plagued by confusion about its purpose. In studying CDOs and their roles over the past decade, the authors identified seven key types of CDO jobs, each distinct enough that it would be difficult or impossible for one person to perform all of them well. Understanding what a given organization expects of its CDO, and then matching capabilities with those expectations, can be the key to longer, more effective, and happier CDO tenures.

Collaboration is key as more companies hive off duties held by IT officers and create positions to better use data and manage emerging tech like ChatGPT.

Comparing snapshots by state shows how many ids have moved from one state to another between 2 snapshots providing insights on bottlenecks.

When people are asked why data storytelling matters, most of the focus is on the benefits that can be derived by the individuals communicating the insights. However, there are two key perspectives to consider when contemplating why it matters--that of the sender and that of the receiver. While individuals will gain much from developing data storytelling skills, it's ultimately the audiences who will be the greater beneficiaries. This article explores how each side benefits from data storytelling and how data stories can collectively enhance your organization's overall success.

A good collaborator offers companionship, a fresh perspective, and can help balance skillsets. Here's how to make a collaboration successful.

This post give you an Overview of Creator Kit. It explain what is Creator Kit for Power Apps and how can we install it. Is good starting point to understand it, and have useful official link to keep you update

Following on from the launch of the new look for model driven apps, we’re making the same modern controls available to canvas apps through an opt in preview. The new controls bring the following improvements:  Modern – A focused and less cluttered design that supports richer interaction states and elevation, provides a higher usability baseline…

Timesheets are a popular app to make in Power Apps. In this step-by-step tutorial, I'll show you how to build your own timesheets app.

AI Copilot overview in Power Apps.

On this page you will find documentation on how to use all 13 of the new Power Apps Modern controls for canvas apps.