Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Find articles, guides, information and community news

Most Recent
Poweraegg
Advocate IV
Advocate IV

Simplify your data models and reduce redundancy in Microsoft Fabric by using a bridge table—a lightweight connector that links multiple fact tables without duplicating dimensions. Learn how to implement this powerful technique in Lakehouse and Power BI for improved performance and scalability.

Read more...

Kumail
Post Prodigy
Post Prodigy

Unlock enterprise-grade version control and CI/CD for your Microsoft Fabric dashboards. Learn how to implement GitHub integration for real-time analytics, complete with code samples and deployment best practices.

Read more...

Poweraegg
Advocate IV
Advocate IV

Unlocking the Power of Direct Lake Mode: A Deep Dive into Microsoft Fabric's Game-Changing Feature

Want to handle billions of rows of data with lightning-fast queries? Microsoft Fabric's Direct Lake mode makes it possible, but only if you know how to harness its full potential. In this comprehensive guide, we reveal the critical optimization strategies that transform this powerful feature from a resource-hungry challenge into a streamlined data powerhouse. From sophisticated throttling mechanisms to advanced compression techniques, discover how to architect your data lake for peak performance while avoiding common pitfalls that can bottleneck your queries.

Read more...

Poweraegg
Advocate IV
Advocate IV

Learn the difference and what it takes to transition to Fabric successfully!

Read more...

Ilgar_Zarbali
Most Valuable Professional
Most Valuable Professional

In this article, we’ll explore the power of X-Functions like SUMX, AVERAGEX, and more, and how they can transform your data modeling in Power BI. Let’s clarify what we mean and dive into practical examples to enhance your analytics workflows.

Downloadble Resources 

Read more...

Ilgar_Zarbali
Most Valuable Professional
Most Valuable Professional

1.png

 

Managing stock levels dynamically is essential for effective inventory management. A crucial aspect of this task involves calculating cumulative quantities to track the balance of products over time. In this example, we have Sales and Purchasing tables, and we aim to create a Matrix visual in Power BI to display the purchased and sold quantities accurately. The ultimate goal is to dynamically track the stock balance (leftover products) at any given point by calculating the difference between cumulative purchases and cumulative sales.

You can download the files related to this article using the following link:
Materials 

Read more...

Kaviraj11
Super User
Super User

Custom Sorting with Power BI

Custom sorting in Power BI can significantly enhance the clarity and impact of your data visualizations. However, users often encounter several challenges when setting up custom sorts. Here’s a look at some of the common hurdles and how to overcome them:

 

Step 1

Create a Custom Table with all the category either manually in Power Query or read from source.

Create a new column beside and provide the number in the order you want to arrange.

Kaviraj11_0-1731095696156.png

 

Step 2

Create a relationship between the column in actual table to the custom sort table.

 

Step 3

Create a column in Actual table with an expression.

Sort order = RELATED(CustomSortTable[Sort])

 

Step 4

Select the column you want to sort, and a “Column Tools” menu bar will appear at the top. Now Select the “Sort by column” and select the sort order column.

Kaviraj11_1-1731095839638.png

 

Read more...

Kumail
Post Prodigy
Post Prodigy

Add a subheading (1).png

Unlocking the potential of Copilot

  • Suggest content for a report
  • Assisted Report Creation
  • Prompt Data Insights
  • DAX Formulation and Description
Read more...

Kumail
Post Prodigy
Post Prodigy

Greetings Power BI enthusiasts!

 

Are you ready to revolutionize the way you interact with your data? Say hello to Natural Language Query (NLQ) – your new best friend in the world of Power BI. In this blog post, we'll explore how NLQ can transform your data analysis experience and empower you to derive meaningful insights effortlessly.

Read more...

Kumail
Post Prodigy
Post Prodigy

What new functions added in DAX during 2022

Read more...

Kumail
Post Prodigy
Post Prodigy

Power BI offers a good set of in-built visuals which you can access and use from the Visualization pane in Power BI Desktop.

Read more...

Fowmy
Super User
Super User

 An interesting DAX challenge with the solution is presented in this video. 

Read more...

ashleyfelts
Administrator
Administrator

Come meet this months featured user group leaders in Power BI!

Read more...

Helpful resources

Join Blog
Interested in blogging for the community? Let us know.