DAX probably has hundreds of functions, however, several of them stand out. In this article, I picked the most useful ones for everyday use and grouped them by functionality. In this section, we will look closely at FILTER functions.

This post features entries to week 4 of the Power BI DataViz World Championships that were called out by judges for their excellence.

This article announces the 4th and final winner of the qualifying rounds of the Power BI DataViz World Championships.

The Problem with Traditional Approval Hierarchies

Many organizations still operate under the illusion that requiring CFO or CEO approval equates to strong financial oversight. However, real-world cases of fraud and inefficiencies tell a different story. These hierarchical approvals:

• Create bottlenecks – Senior leaders are often overwhelmed with approvals, leading to delays and inefficiencies.
• Encourage superficial reviews – Executives rarely have time to deeply analyze each request, turning approvals into a formality.
• Do not effectively mitigate risk – Fraud often happens at executive levels, where transactions are approved under the guise of authority, bypassing real scrutiny.
• Give unchecked power to human bias – Approvals become a tool for reinforcing personal agendas, favoritism, and misallocation of company resources.
• Preserve budget control at the top – Budget allocation is the ultimate power in corporations, and those in senior roles are reluctant to relinquish control, even if AI can distribute resources more fairly and efficiently.

Instead of safeguarding company resources, traditional approval hierarchies often consolidate power among a few individuals who may have their own financial interests in mind.

In this blog, we will walk through the step-by-step process of calculating a cumulative sum by Product ID using a DAX measure in Power BI. This technique is particularly useful for tracking running totals in sales, revenue, or other numerical data over time.

This post recognizes the featured entries from week 3 of the Power BI DataViz World Championships.

Dynamic per recipient subscriptions is similar as dynamic subscriptions for paginated reports, we can now send a personalized version of a Power BI report to each individual recipient of an email subscription.These functionality allows the dissemination of unique views of the same report by applying specific filters based on individual user preferences, all seamlessly managed within a single subscription

This post announces the winner of the 3rd qualifying round of the Power BI DataViz World Championships.

This post introduces the final challenge of the qualifying rounds for the Power BI DataViz World Championships.

Editing the json content in PBIP files seems to allow the setting of dynamic expressions in place of static property values - even if the Power BI UI does not provide an fx button. It seems any property can be set dynamically!

In this article, we would be learning how to add a gradient text in Power BI. A gradient is a smooth transition between two or more colors. Instead of displaying a solid color, a gradient blends multiple colors together in a seamless way (screenshot below).

At the moment, there isn't a straight forward way to have graident text in a textbox/shape or a card visual. We need to import an html code for it. Here's how we can do it. 

This article features submissions from Week 2 of the Power BI DataViz World Championships.

This post crowns the week 2 winner of the Power BI DataViz World Championships!

Appending queries in Power BI is a powerful feature that allows you to combine two or more data tables effortlessly. This is particularly useful when working with datasets that are split across multiple files or years. In this blog, we will walk through the process of appending two different queries using Power BI.

This post introduces accessibility concepts for Power BI and how to easily implement basic standards.