Power BI

Video by: Reid Havens Learn how to apply some [DAX] wizardry to intelligently format string values when concatenating KPI values together. RELATED CONTENT 🔗 Kane Snyder's Calculation Group Presentation Jeff Weir's Twitter Post

Charting time magnitudes and displaying hours and minutes in the data label is not straight forward in Power BI, but can be achieved with a Calculation group

The Data Type in a DAX Column is explained in this detailed article from Greg Baldini. This can be observed when using Dynamic Ranking.

Get the list of default icon names in Power BI for conditional formatting and learn how to use it in a DAX expression

List of the most common univariate statistics DAX functions available in Power BI, as of now most of them are built-in functions but the more complex ones still require writing some Dax code. The list will be kept up to date please let me know if you thing a function is missing. eyJrIjoiNzFjZDkwNTkt...

Part two in this series on Power BI Aggregation tables focuses on Power BI data models with more than one aggregation table. The first article introduced Power BI Aggregations and included a walk through configuring a Power BI model with a single aggregation table. Intro to Power BI Aggregations Multiple aggregations tables DUAL storage mode … Continue reading Power BI Multiple Aggregations tables

There are some cases that we want to add a leading zero to a digit, such as showing 01 instead of 1, 02 instead of 2 and so on. We have two options to do this in Power BI, doing it in Power Query or doing it with DAX. Adding a Leading Zero in Power … Continue reading Quick Tips: Adding Leading Zero to Integer Values (Padding) with DAX and Power Query

Find out which visuals in your Power BI report generated a given DAX query

This article introduces the Power BI User-defined Aggregations feature. It includes a walkthrough example (with video) showing how to configure and test a simple model to use this feature. If you have not used Power BI User-defined Aggregations before, need a refresher or reminder, or are just keen to understand how to configure, this article … Continue reading Intro to Power BI Aggregations

Here you will find blogs related to Power BI, DAX, Power Query, VBA, Excel and much more. Power BI | Antmanbi.com

The popularity of Power BI has increased dramatically in the past few years. I am seeing an increasing number of enterprise customers who built complex composite models combining import tables with DirectQuery tables. Many users have asked questions on how DAX queries and measures are tran

Shared via Flipboard

This story is intended to share small bits of code that I have found extremely useful in my day to day activities as a Power BI consultant.

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 »

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.

We all write our codes in a proper format so that readability and understanding of codes become easy. While working with POWER BI, we use DAX Expressions to write our measures and calculated columns. We know that formatting is not required in DAX. It’s normal to see DAX expressions that span over 10...

We are happy to share that new items are available to use in CI/CD. You can also build a full E2E automated CI/CD with Fabric APIs. Click to read more, and learn about additional announcements.

Leverage the power of task flows to design and build your data solutions and manage workspace items in Microsoft Fabric. We’re thrilled to announce that the task flows feature is now in public preview and is enabled for all existing Microsoft Fabric users. Fabric is unifying everything needed to deliver end-to-end data and analytics solutions … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/announcing-the-public-preview-of-task-flows-in-microsoft-fabric/" class="more-link">Continue reading<span class="screen-reader-text"> “Announcing the public preview of task flows in Microsoft Fabric”</span></a>

To improve the flexibility for copying data in Fabric Data Factory, we are excited to announce that now you can edit destination table column types when copying data!  Supported scenarios This new feature allows you to edit the data type of the column for a new or auto-created destination table, if your data destination is … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/edit-the-destination-table-column-type-when-copying-data-to-lakehouse-table-data-warehouse-and-sql-data-stores/" class="more-link">Continue reading<span class="screen-reader-text"> “Edit the Destination Table Column Type when Copying Data to Lakehouse Table, Data Warehouse and SQL Data Stores “</span></a>

Managing data connections in Microsoft Fabric can be challenging if you’re unsure where to start. This blog post and its detailed YouTube video will help you find, manage, and share the existing data connections, making your workflow more efficient and streamlined. A meaningful use case for this feature is to reuse the existing connections leading … Continue reading Microsoft Fabric Connections Demystified

Welcome to our deep dive into Microsoft Fabric! If you’re navigating the complexities of Microsoft Fabric, one critical aspect you’ll want to master is understanding the cost of each ac…

This article gives an overview of task flows and task flow terminology.

<p>AI models are improving rapidly, and customers need effective tools to integrate AI into their business solutions that provide precise, reliable and consistent information, and are easy to deploy. Today we are happy to announce our latest improvements to help makers integrate AI into their low-code apps and solutions. Now available as Public Preview in Microsoft Copilot Studio, data grounding with Dataverse tables allows makers to create powerful AI prompts that are grounded with their enterprise data while enforcing real time enterprise security. Additionally, we are excited to announce that low-code plugins now support five new AI Power Fx functions, and share  how Capgemini New Zealand, a global leader in consulting, technology services and digital transformation, is leveraging these new capabilities to create value for their clients and solve business problems faster than ever before.</p>

This month, we are excited to announce some new and exciting updates to Copilot; Copilot for consumers now includes support for Apps. Updates to Copilot geography support, usage and billing updates and abuse monitoring changes.

Uncover a host of updates and enhancements to our new card visual reference labels. This February 2024 update brings many great features including improved alignment of elements, new placement options for reference labels, a new tabular style, a transparency slider for the divider, new per-card customization, and enhanced layout control.

Welcome to November and a new version of the on-premises data gateway! We are excited to announce a new feature for allowlisting which tenants can register an on-premises data gateway on a machine. Read the post to find out more.

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...

Here’s our September release of the on-premises data gateway! As always, stay up to date for the latest functionality.

Announcing public preview on managing Power BI reports and datasets native components in Power Apps Solution