IGLOO BI

When you begin to delve deeper into Power BI, an inevitable question arises at least once: "Aren't both VALUES and DISTINCT simply used for removing duplicates?" "The results look practically identical, so why does everyone use VALUES as the default?" "Honestly, at first glance, using DISTINCT doesn't seem to cause any major issues, does it?" In fact, when I first encountered DAX, I did not noticeably perceive the difference between the two either. This is because in simple sample datasets, the outputs appear almost identical. However, the moment real-world production data is introduced, the narrative changes entirely. Especially when: Discrepancies occur between ERP and online mall product codes, The registration of a new product SKU is delayed, or ...

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