IGLOO BI

In the previous post, we covered the basic concepts of Dynamic Format Strings in Power BI. In this installment, we take it a step further by introducing core patterns used directly in the field: • “Reports where units change automatically based on the indicator (KPI)” • “Advanced design that expresses both % and currency within a single column” In practice, I have seen many cases where reports become unnecessarily complex due to these requirements. Especially as the number of KPIs increases, “unit management” becomes increasingly tedious. This article summarizes how to solve this problem cleanly. ✔ When a KPI is selected → Automatic unit change ✔ In tables → Rows show %, Totals show currency ✔ With 1 column → Simultaneous expression of Weight + Total These are patterns you can apply immediately in...

When creating reports, we often face the same dilemma: "I want to see both Sales and Growth Rate—do I have to create two separate charts?" The feature that solves this inefficiency in one go is Field Parameters . In this article, we will cover everything from switching multiple KPIs in a single chart to applying dynamic formatting, all in a practical way you can use immediately. 1. What are Field Parameters? (Conceptual Understanding) When you utilize the Power BI Field Parameters feature in a chart, it allows the axis (X-axis) or values (Y-axis) to swap in real-time based on the selection a user makes in a slicer. • The Old Way: You had to create complex SWITCH function measures or overlap multiple charts using the 'Bookmark' feature. • The Current Way: Dynamic chart control is possible with just a few clicks, and maintenance is extremely easy. As a re...

"When you first input data into a Power BI matrix, it appears in its ‘Default State’—without any formatting applied. Since the table options are set to system defaults, the lack of organization in lines, spacing, and colors often results in an awkward and unfinished look." In this article, we will pinpoint why matrices in their initial state look unrefined. We will then walk through a step-by-step transformation into a polished report by adjusting Borders , Row Padding , and Background Colors . 1. Why Power BI Matrices Lack a Bottom Border The default Power BI style, 'Default,' displays only the divider lines between data rows, while the Outer Border of the visual object is turned off by default. • Bottom of Column Headers: A line is inserted to distinguish between headers and data. • Between Data Rows: A faint line is inserted to separate individual rows. ...

Strategic Introduction: The Final 1% of Data Clarity "In our previous session, we covered how to improve data visibility by grouping complex Ribbon Charts into 'Top N' and 'Other.' While we successfully reduced visual clutter, one 'detail gap' still remains: the Sort Order of the Legend. In a Ribbon Chart, legend sorting is more than just a list. If the flow of the data doesn't align with the user’s gaze, it creates a bottleneck in interpretation, no matter how well-organized the data is. In this post, we will look at a dedicated logic called 'Brand Sort Order.' I will show you how to move beyond simple alphabetical sorting and master your charts based on actual business contribution." 1. The Essence of the Problem: "The Sort Criteria Does Not Align with the Flow" By default, Power BI Ribbon Charts list legends in alphabetical or numerica...

"I have found that as Ribbon Charts in a dashboard become more elaborate, their analytical value often tends to decrease. A visualization that attempts to show everything frequently ends up communicating nothing. When a chart contains too many categories, it simply creates 'visual noise' that obscures the core signals needed for decision-making. The 'Top N + Other' strategy is more than just a filter. Its core purpose is to create a refined flow that highlights key players while still allowing the user to grasp the overall market scale through a consolidated 'Other' group. In this guide, I will share a practical methodology for transforming cluttered visuals into clear, high-density reports. We will walk through how to use DAX to dynamically group low-contribution variables, ensuring your Ribbon Charts deliver strategic value at a single glance." 1. The Fatal Weakness of Ribbon Charts: Data 'Noise' The purpose of...