{"id":3086,"date":"2024-07-17T17:52:00","date_gmt":"2024-07-17T15:52:00","guid":{"rendered":"https:\/\/dev.mdw-group.com\/?p=3086"},"modified":"2026-02-02T10:09:09","modified_gmt":"2026-02-02T09:09:09","slug":"simplify-your-power-bi-reports","status":"publish","type":"post","link":"https:\/\/mdw-group.com\/es\/simplify-your-power-bi-reports\/","title":{"rendered":"Simplifica tus Informes de Power BI"},"content":{"rendered":"\n<div class=\"wp-block-uagb-container uagb-block-11ca5130 alignfull uagb-is-root-container\">\n<div class=\"wp-block-uagb-container uagb-block-4761adb6\">\n<div class=\"wp-block-uagb-advanced-heading uagb-block-0337d147\"><h2 class=\"uagb-heading-text\">Simplify Your Power BI Reports<\/h2><\/div>\n\n\n\n<div class=\"wp-block-uagb-separator uagb-block-090a325d\"><div class=\"uagb-separator-spacing-wrapper\"><div class=\"wp-block-uagb-separator__inner\" style=\"--my-background-image:\"><\/div><\/div><\/div>\n\n\n<div class=\"has-text-align-center wp-block-post-date\"><time datetime=\"2024-07-17T17:52:00+02:00\">julio 17, 2024<\/time><\/div><\/div>\n\n\n\n<div class=\"wp-block-uagb-container uagb-block-1d42d899 alignfull uagb-is-root-container\"><div class=\"uagb-container-inner-blocks-wrap\">\n<h2 class=\"wp-block-heading has-text-color has-link-color wp-elements-1\" style=\"color:#731373\"><strong>Optimize Dynamic KPIs in Power BI with Calculation Groups<\/strong><\/h2>\n\n\n\n<p class=\"has-ast-global-color-8-color has-text-color has-link-color wp-elements-2 wp-block-paragraph\">Optimize Dynamic KPIs in Power BI with Calculation Groups<\/p>\n\n\n\n<h2 class=\"wp-block-heading has-text-color has-link-color wp-elements-3\" style=\"color:#731373\"><strong>Too Many KPIs, Too Many Measures<\/strong><\/h2>\n\n\n\n<p class=\"has-ast-global-color-8-color has-text-color has-link-color wp-elements-4 wp-block-paragraph\">Have you ever built a report with more than 40 KPIs? If so, you know the pain: each KPI needs its own measure plus extra calculations for year-over-year comparisons, period variations, and more. When you add a new KPI, you repeat the whole process.<br><br>Calculation groups solve much of this problem, but they also come with limits. Imagine you want to show three values on one card: the actual KPI, last year\u2019s value, and the difference. Time intelligence calculation groups help with part of this, but Power BI does not let you display multiple calculation items in the same visual.<\/p>\n\n\n\n<h2 class=\"wp-block-heading has-text-color has-link-color wp-elements-5\" style=\"color:#731373\"><strong>Why Calculation Groups Matter<\/strong><\/h2>\n\n\n\n<p class=\"has-ast-global-color-8-color has-text-color has-link-color wp-elements-6 wp-block-paragraph\">Calculation groups were designed to reduce this complexity. They let you define reusable logic instead of duplicating measures. However, they also have limits. Even if you\u2019ve configured time intelligence calculation groups, you can\u2019t apply multiple calculation items to the same visual. That\u2019s a problem for KPI reporting.<\/p>\n\n\n\n<h2 class=\"wp-block-heading has-text-color has-link-color wp-elements-7\" style=\"color:#731373\"><strong>The Goal<\/strong><\/h2>\n\n\n\n<p class=\"has-ast-global-color-8-color has-text-color has-link-color wp-elements-8 wp-block-paragraph\">In this article, we\u2019ll combine calculation groups with conditional logic. This technique allows you to:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li class=\"has-ast-global-color-7-color has-text-color has-link-color wp-elements-9\" style=\"margin-top:0;margin-bottom:0;padding-top:0;padding-bottom:0\">Display dynamic KPIs in one card.<\/li>\n\n\n\n<li class=\"has-ast-global-color-7-color has-text-color has-link-color wp-elements-10\">Reuse the same structure across multiple visuals.<\/li>\n\n\n\n<li class=\"has-ast-global-color-7-color has-text-color has-link-color wp-elements-11\">Add new KPIs easily by writing just one formula.<\/li>\n\n\n\n<li class=\"has-ast-global-color-7-color has-text-color has-link-color wp-elements-12\">Keep consistent business logic across all measures.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading has-text-color has-link-color wp-elements-13\" style=\"color:#731373\"><strong>Step 1: Create a KPI Table<\/strong><\/h2>\n\n\n\n<p class=\"has-ast-global-color-8-color has-text-color has-link-color wp-elements-14 wp-block-paragraph\">The foundation of this approach is a dedicated KPI table. It contains every KPI in your report and can also serve as documentation or a dictionary.<br>A simple structure might include:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li class=\"has-ast-global-color-7-color has-text-color has-link-color wp-elements-15\"><strong>ID<\/strong> and <strong>Measure Name<\/strong>.<\/li>\n\n\n\n<li class=\"has-ast-global-color-7-color has-text-color has-link-color wp-elements-16\">Optional fields like <strong>Description<\/strong>, <strong>Comments<\/strong>, or <strong>Format<\/strong>.<\/li>\n\n\n\n<li class=\"has-ast-global-color-7-color has-text-color has-link-color wp-elements-17\" style=\"margin-top:0;margin-bottom:0\">A column for <strong>Negative is good<\/strong> to handle conditional colors. For example, a drop in COGS is positive, so you display it in green.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><noscript><img decoding=\"async\" width=\"555\" height=\"127\" data-skip-lazy src=\"https:\/\/dev.mdw-group.com\/wp-content\/uploads\/2024\/09\/image-69.png\" alt=\"\" class=\"wp-image-3087\" srcset=\"https:\/\/mdw-group.com\/wp-content\/uploads\/2024\/09\/image-69.png 555w, https:\/\/mdw-group.com\/wp-content\/uploads\/2024\/09\/image-69-300x69.png 300w, https:\/\/mdw-group.com\/wp-content\/uploads\/2024\/09\/image-69-500x114.png 500w\" sizes=\"(max-width: 555px) 100vw, 555px\" \/><\/noscript><img decoding=\"async\" width=\"555\" height=\"127\" src=\"https:\/\/dev.mdw-group.com\/wp-content\/uploads\/2024\/09\/image-69.png\" alt class=\"wp-image-3087 vp-lazyload\" srcset=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iNTU1IiBoZWlnaHQ9IjEyNyIgdmlld0JveD0iMCAwIDU1NSAxMjciIGZpbGw9Im5vbmUiIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyI+PC9zdmc+\" data-src=\"https:\/\/dev.mdw-group.com\/wp-content\/uploads\/2024\/09\/image-69.png\" data-srcset=\"https:\/\/mdw-group.com\/wp-content\/uploads\/2024\/09\/image-69.png 555w, https:\/\/mdw-group.com\/wp-content\/uploads\/2024\/09\/image-69-300x69.png 300w, https:\/\/mdw-group.com\/wp-content\/uploads\/2024\/09\/image-69-500x114.png 500w\" data-sizes=\"auto\" loading=\"eager\"><\/figure>\n\n\n\n<p class=\"has-ast-global-color-8-color has-text-color has-link-color wp-elements-18 wp-block-paragraph\">This last column is especially useful. It lets you apply green or red colors dynamically depending on whether the KPI going up or down is good for the business. For example, an increase in Sales should be green, but a decrease in COGS should also be green. Whenever you add a new KPI, just add a row to this table with its name and attributes.<\/p>\n\n\n\n<h2 class=\"wp-block-heading has-text-color has-link-color wp-elements-19\" style=\"color:#731373\"><strong>Step 2: Prepare Auxiliary Measures<\/strong><\/h2>\n\n\n\n<p class=\"has-ast-global-color-8-color has-text-color has-link-color wp-elements-20 wp-block-paragraph\">Next, create placeholder measures. These control how the calculation group logic works.<\/p>\n\n\n\n<pre class=\"wp-block-code has-black-color has-text-color has-background has-link-color wp-elements-21\" style=\"background-color:#f0f0f0\"><code>&#91;DAX CODE] dyn_Actual = BLANK ()\n&#91;DAX CODE] dyn_Var_Title = \"\"\n&#91;DAX CODE] dyn_Var_Value = BLANK ()\n&#91;DAX CODE] dyn_Var_Detail = BLANK ()\n&#91;DAX CODE] dyn_Colour = \"\"<\/code><\/pre>\n\n\n\n<p class=\"has-ast-global-color-8-color has-text-color has-link-color wp-elements-22 wp-block-paragraph\">Each one maps to a section of the card visual:<\/p>\n\n\n\n<pre class=\"wp-block-code has-black-color has-text-color has-background has-link-color wp-elements-23\" style=\"background-color:#f0f0f0\"><code>dyn_Actual \u2192 main callout value.\ndyn_Var_Title \u2192 reference label title.\ndyn_Var_Value \u2192 reference label value.\ndyn_Var_Detail \u2192 reference label detail.\ndyn_Colour \u2192 conditional color for labels.<\/code><\/pre>\n\n\n\n<p class=\"has-ast-global-color-8-color has-text-color has-link-color wp-elements-24 wp-block-paragraph\">You also need your base KPI measures. For example, <code>[COGS]<\/code> and <code>[Sales]<\/code> as sums of their fact table columns.<\/p>\n\n\n\n<h2 class=\"wp-block-heading has-text-color has-link-color wp-elements-25\" style=\"color:#731373\"><strong>Step 3: Build the Card Visual<\/strong><\/h2>\n\n\n\n<p class=\"has-ast-global-color-8-color has-text-color has-link-color wp-elements-26 wp-block-paragraph\">Create a card visual. Set the <strong>title<\/strong> to display the first value of the <em>Measure Name<\/em> column. Assign the measures:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><noscript><img decoding=\"async\" width=\"251\" height=\"172\" data-skip-lazy src=\"https:\/\/dev.mdw-group.com\/wp-content\/uploads\/2024\/09\/image-70.png\" alt=\"\" class=\"wp-image-3088\"\/><\/noscript><img decoding=\"async\" width=\"251\" height=\"172\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMjUxIiBoZWlnaHQ9IjE3MiIgdmlld0JveD0iMCAwIDI1MSAxNzIiIGZpbGw9Im5vbmUiIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyI+PC9zdmc+\" alt class=\"wp-image-3088 vp-lazyload\" data-src=\"https:\/\/dev.mdw-group.com\/wp-content\/uploads\/2024\/09\/image-70.png\" data-sizes=\"auto\" loading=\"eager\"><\/figure>\n\n\n\n<p class=\"has-ast-global-color-8-color has-text-color has-link-color wp-elements-27 wp-block-paragraph\">Set the title to show the first value from Measure Name in the KPI table.<\/p>\n\n\n\n<pre class=\"wp-block-code has-black-color has-text-color has-background has-link-color wp-elements-28\" style=\"background-color:#f0f0f0\"><code>Place dyn_Actual in the callout field.\nPlace dyn_Var_Value in the reference label.\nPlace dyn_Var_Title and dyn_Var_Detail in the title and detail fields of the reference label.<\/code><\/pre>\n\n\n\n<p class=\"has-ast-global-color-8-color has-text-color has-link-color wp-elements-29 wp-block-paragraph\">At this stage, the values are placeholders. The real logic will come from calculation groups.<\/p>\n\n\n\n<h2 class=\"wp-block-heading has-text-color has-link-color wp-elements-30\" style=\"color:#731373\"><strong>Step 4: Create the Calculation Group<\/strong><\/h2>\n\n\n\n<p class=\"has-ast-global-color-8-color has-text-color has-link-color wp-elements-31 wp-block-paragraph\"><strong>Actual Value<\/strong><br>First, create a calculation item to select the right measure based on the KPI filter.<\/p>\n\n\n\n<pre class=\"wp-block-code has-black-color has-text-color has-background has-link-color wp-elements-32\" style=\"background-color:#f0f0f0\"><code>valueActual =\nSWITCH (\n    SELECTEDVALUE ( _Measures&#91;Measure Name] ),\n    \"COGS\", &#91;COGS],\n    \"Sales\", &#91;Sales]\n)<\/code><\/pre>\n\n\n\n<p class=\"has-ast-global-color-8-color has-text-color has-link-color wp-elements-33 wp-block-paragraph\">When adding a new KPI, extend this <code>SWITCH<\/code> with the KPI name and its corresponding measure.<\/p>\n\n\n\n<p class=\"has-ast-global-color-8-color has-text-color has-link-color wp-elements-34 wp-block-paragraph\"><strong>Last Year Value<br><\/strong>Next, reference the actual value to calculate last year\u2019s result:<\/p>\n\n\n\n<pre class=\"wp-block-code has-black-color has-text-color has-background has-link-color wp-elements-35\" style=\"background-color:#f0f0f0\"><code>&#91;DAX CODE] valueLastYear =\nCALCULATE (\n    SELECTEDMEASURE (),\n    'Smart KPIs'&#91;Calculation] = \"valueActual\",\n    SAMEPERIODLASTYEAR ( 'Calendar'&#91;Date] )\n)<\/code><\/pre>\n\n\n\n<p class=\"has-ast-global-color-8-color has-text-color has-link-color wp-elements-36 wp-block-paragraph\"><strong>Absolute Variation<br><\/strong>Now calculate the absolute difference between current and last year:<\/p>\n\n\n\n<pre class=\"wp-block-code has-black-color has-text-color has-background has-link-color wp-elements-37\" style=\"background-color:#f0f0f0\"><code>&#91;DAX CODE] valueVariationAbs =\nVAR __VALUE_ACTUAL =\n    CALCULATE (\n        SELECTEDMEASURE (),\n        'Smart KPIs'&#91;Calculation] = \"valueActual\"\n    )\nVAR __VALUE_LAST_YEAR =\n    CALCULATE (\n        SELECTEDMEASURE (),\n        'Smart KPIs'&#91;Calculation] = \"valueLastYear\"\n    )\nRETURN\n    __VALUE_ACTUAL - __VALUE_LAST_YEAR<\/code><\/pre>\n\n\n\n<p class=\"has-ast-global-color-8-color has-text-color has-link-color wp-elements-38 wp-block-paragraph\"><strong>Percentage Variation<br><\/strong>Finally, compute the percentage difference:<\/p>\n\n\n\n<pre class=\"wp-block-code has-black-color has-text-color has-background has-link-color wp-elements-39\" style=\"background-color:#f0f0f0\"><code>&#91;DAX CODE] valueVariationPerc =\nVAR __VALUE_ACTUAL =\n    CALCULATE (\n        SELECTEDMEASURE (),\n        'Smart KPIs'&#91;Calculation] = \"valueActual\"\n    )\nVAR __VALUE_LAST_YEAR =\n    CALCULATE (\n        SELECTEDMEASURE (),\n        'Smart KPIs'&#91;Calculation] = \"valueLastYear\"\n    )\nRETURN\n    DIVIDE (\n        __VALUE_ACTUAL - __VALUE_LAST_YEAR,\n        __VALUE_LAST_YEAR\n    )<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading has-text-color has-link-color wp-elements-40\" style=\"color:#731373\"><strong>Step 5: Control Card Output<\/strong><\/h2>\n\n\n\n<p class=\"has-black-color has-text-color has-link-color wp-elements-41 wp-block-paragraph\">As you can see in the code above, SELECTEDMEASURE() will always reference the original dyn_Actual or other blank DAX measures. This is not important, as when Power BI applies the valueActual calculation item, it will override the blank value for the corresponding measure that we are indicating with a filter. Finally, we can create a new calculation item that references all of the previous items and controls which one is used in each section of the card visual.<\/p>\n\n\n\n<div class=\"wp-block-uagb-separator uagb-block-b368eacb\"><div class=\"uagb-separator-spacing-wrapper\"><div class=\"wp-block-uagb-separator__inner\" style=\"--my-background-image:\"><\/div><\/div><\/div>\n\n\n\n<pre class=\"wp-block-code has-black-color has-text-color has-background has-link-color wp-elements-42\" style=\"background-color:#f0f0f0\"><code>&#91;DAX CODE] Card =\nVAR __VALUE_VAR_ABS =\n    CALCULATE ( SELECTEDMEASURE (), 'Smart KPIs'&#91;Calculation] = \"valueVariationAbs\" )\nRETURN\n    SWITCH (\n        TRUE (),\n        ISSELECTEDMEASURE ( &#91;dyn_Actual] ),\n            CALCULATE ( SELECTEDMEASURE (), 'Smart KPIs'&#91;Calculation] = \"valueActual\" ),\n        ISSELECTEDMEASURE ( &#91;dyn_Var_Title] ),\n            SWITCH (\n                TRUE (),\n                __VALUE_VAR_ABS &lt; 0, \"\u2800\u25bc \",\n                __VALUE_VAR_ABS = 0, \"\u2800\",\n                __VALUE_VAR_ABS &gt; 0, \"\u2800\u25b2 \"\n            ),\n        ISSELECTEDMEASURE ( &#91;dyn_Var_Value] ),\n            __VALUE_VAR_ABS,\n        ISSELECTEDMEASURE ( &#91;dyn_Var_Detail] ),\n            CALCULATE ( SELECTEDMEASURE (), 'Smart KPIs'&#91;Calculation] = \"valueVariationPerc\" ),\n        ISSELECTEDMEASURE ( &#91;dyn_Color] ),\n            VAR __VALUE_ADJUSTED =\n                __VALUE_VAR_ABS\n                * POWER ( -1, INT ( SELECTEDVALUE ( _Measures&#91;Negative is good] ) ) )\n            RETURN\n                SWITCH (\n                    TRUE (),\n                    __VALUE_ADJUSTED &lt; 0, \"#D64550\",    -- Red\n                    __VALUE_ADJUSTED = 0, \"#000000\",    -- Black\n                    __VALUE_ADJUSTED &gt; 0, \"#6F9F2F\"     -- Green\n                )\n    )<\/code><\/pre>\n\n\n\n<p class=\"has-ast-global-color-8-color has-text-color has-link-color wp-elements-43 wp-block-paragraph\"><code>ISSELECTEDMEASURE<\/code> is the key to making the card dynamic. It tells Power BI which placeholder measure is running and applies the right logic: actual value, arrow, variation, percentage, or color. With this single calculation item, you can control every part of the card in a consistent way. Once the logic is in place, move to the visual. Add a few filters to the card, and its behavior becomes dynamic and fully automated.<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><noscript><img decoding=\"async\" width=\"476\" height=\"194\" data-skip-lazy src=\"https:\/\/dev.mdw-group.com\/wp-content\/uploads\/2024\/09\/image-71.png\" alt=\"\" class=\"wp-image-3089\" srcset=\"https:\/\/mdw-group.com\/wp-content\/uploads\/2024\/09\/image-71.png 476w, https:\/\/mdw-group.com\/wp-content\/uploads\/2024\/09\/image-71-300x122.png 300w\" sizes=\"(max-width: 476px) 100vw, 476px\" \/><\/noscript><img decoding=\"async\" width=\"476\" height=\"194\" src=\"https:\/\/dev.mdw-group.com\/wp-content\/uploads\/2024\/09\/image-71.png\" alt class=\"wp-image-3089 vp-lazyload\" srcset=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iNDc2IiBoZWlnaHQ9IjE5NCIgdmlld0JveD0iMCAwIDQ3NiAxOTQiIGZpbGw9Im5vbmUiIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyI+PC9zdmc+\" data-src=\"https:\/\/dev.mdw-group.com\/wp-content\/uploads\/2024\/09\/image-71.png\" data-srcset=\"https:\/\/mdw-group.com\/wp-content\/uploads\/2024\/09\/image-71.png 476w, https:\/\/mdw-group.com\/wp-content\/uploads\/2024\/09\/image-71-300x122.png 300w\" data-sizes=\"auto\" loading=\"eager\"><\/figure>\n\n\n\n<p class=\"has-ast-global-color-8-color has-text-color has-link-color wp-elements-44 wp-block-paragraph\">\u2018Calculation\u2019 is the name of the calculation group column. The card already looks good, but the formatting still needs improvement. We want both the callout value and the reference label value displayed in <strong>millions of euros<\/strong>. Negative symbols are unnecessary, because arrows and dynamic colors already show the trend. Removing those symbols avoids confusing users with redundant cues.<\/p>\n\n\n\n<p class=\"has-ast-global-color-8-color has-text-color has-link-color wp-elements-45 wp-block-paragraph\">For that, we can use <strong>custom format strings<\/strong> in the field settings.<\/p>\n\n\n\n<ul class=\"wp-block-list has-ast-global-color-7-color has-text-color has-link-color wp-elements-46\">\n<li><strong>Callout value<\/strong>: Use <code>##0,,.0 M\u20ac<\/code>. This divides the number by one million and adds \u201cM\u20ac\u201d at the end.<\/li>\n\n\n\n<li>Reference label value: Use <code>##0,,.00 M\u20ac;##0,,.00 M\u20ac;0 \u20ac<\/code>. Both positive and negative values appear the same. If the value is zero, the \u201cM\u201d for millions is hidden.<\/li>\n\n\n\n<li><strong>Reference label detail<\/strong>: Use <code>(0.0%);(0.0%);0%<\/code>. Percentages appear in parentheses, without negative signs, and with one decimal place so they don\u2019t take up too much space.<\/li>\n<\/ul>\n\n\n\n<p class=\"has-ast-global-color-8-color has-text-color has-link-color wp-elements-47 wp-block-paragraph\">With the addition of the dyn_Color measure in the conditional formatting, we have finally created the \u2018smart KPI card\u2019.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><noscript><img decoding=\"async\" width=\"253\" height=\"170\" data-skip-lazy src=\"https:\/\/dev.mdw-group.com\/wp-content\/uploads\/2024\/09\/image-73.png\" alt=\"\" class=\"wp-image-3091\"\/><\/noscript><img decoding=\"async\" width=\"253\" height=\"170\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMjUzIiBoZWlnaHQ9IjE3MCIgdmlld0JveD0iMCAwIDI1MyAxNzAiIGZpbGw9Im5vbmUiIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyI+PC9zdmc+\" alt class=\"wp-image-3091 vp-lazyload\" data-src=\"https:\/\/dev.mdw-group.com\/wp-content\/uploads\/2024\/09\/image-73.png\" data-sizes=\"auto\" loading=\"eager\"><\/figure>\n\n\n\n<h2 class=\"wp-block-heading has-text-color has-link-color wp-elements-48\" style=\"color:#731373\"><strong><strong>The Result: A Smart KPI Card<\/strong><\/strong><\/h2>\n\n\n\n<p class=\"has-ast-global-color-8-color has-text-color has-link-color wp-elements-49 wp-block-paragraph\">You now have a dynamic card that adapts to any KPI. To add another, simply copy the card and change the <em>Measure Name<\/em> filter. The logic automatically adjusts, and slicers interact smoothly.<br>The arrows and colors respond dynamically:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li class=\"has-ast-global-color-7-color has-text-color has-link-color wp-elements-50\">Green for positive outcomes.<\/li>\n\n\n\n<li class=\"has-ast-global-color-7-color has-text-color has-link-color wp-elements-51\">Red for negative.<\/li>\n\n\n\n<li class=\"has-ast-global-color-7-color has-text-color has-link-color wp-elements-52\">Black for neutral.<\/li>\n<\/ul>\n\n\n\n<p class=\"has-ast-global-color-8-color has-text-color has-link-color wp-elements-53 wp-block-paragraph\">And the \u201cNegative is good\u201d flag ensures the color logic matches the KPI\u2019s business meaning.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><noscript><img decoding=\"async\" width=\"254\" height=\"219\" data-skip-lazy src=\"https:\/\/dev.mdw-group.com\/wp-content\/uploads\/2024\/09\/image-74.png\" alt=\"\" class=\"wp-image-3092\"\/><\/noscript><img decoding=\"async\" width=\"254\" height=\"219\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMjU0IiBoZWlnaHQ9IjIxOSIgdmlld0JveD0iMCAwIDI1NCAyMTkiIGZpbGw9Im5vbmUiIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyI+PC9zdmc+\" alt class=\"wp-image-3092 vp-lazyload\" data-src=\"https:\/\/dev.mdw-group.com\/wp-content\/uploads\/2024\/09\/image-74.png\" data-sizes=\"auto\" loading=\"eager\"><\/figure>\n\n\n\n<h2 class=\"wp-block-heading has-text-color has-link-color wp-elements-54\" style=\"color:#731373\"><strong><strong><strong>Wrapping up<\/strong><\/strong><\/strong><\/h2>\n\n\n\n<p class=\"has-ast-global-color-8-color has-text-color has-link-color wp-elements-55 wp-block-paragraph\">This approach creates a <strong>building block<\/strong> for KPI reporting. Instead of building dozens of custom visuals, you design once and reuse. The technique is highly customizable:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li class=\"has-ast-global-color-7-color has-text-color has-link-color wp-elements-56\">Extend the KPI table with more metadata like formats or descriptions.<\/li>\n\n\n\n<li class=\"has-ast-global-color-7-color has-text-color has-link-color wp-elements-57\">Use calculation group format strings for dynamic rounding (units, thousands, or millions).<\/li>\n\n\n\n<li class=\"has-ast-global-color-7-color has-text-color has-link-color wp-elements-58\">Keep all formatting and logic centralized in one place.<\/li>\n<\/ul>\n\n\n\n<p class=\"has-ast-global-color-8-color has-text-color has-link-color wp-elements-59 wp-block-paragraph\">Mastering this method saves hours of repetitive work and ensures consistency across all reports.<br><br>\ud83d\udc49 If you\u2019re interested in discovering how Microsoft Power BI can benefit your business, schedule a free workshop with our experts now:&nbsp;<a href=\"http:\/\/www.mdw-group.com\/contact\/\" target=\"_blank\" rel=\"noreferrer noopener\">www.mdw-group.com\/contact\/<\/a><\/p>\n\n\n\n<div class=\"wp-block-uagb-separator uagb-block-bd4a6b91\"><div class=\"uagb-separator-spacing-wrapper\"><div class=\"wp-block-uagb-separator__inner\" style=\"--my-background-image:\"><\/div><\/div><\/div>\n\n\n\n<h2 class=\"wp-block-heading has-text-color has-link-color wp-elements-60\" style=\"color:#731373\"><strong><strong><strong>About MDW<\/strong><\/strong><\/strong><\/h2>\n\n\n\n<p class=\"has-ast-global-color-8-color has-text-color has-link-color wp-elements-61 wp-block-paragraph\">MDW is a European consulting firm specialized in <strong>Data &amp; AI<\/strong>. Recognized as <strong>Microsoft Partner of the Year for Azure (2024)<\/strong> and <strong>Partner of the Year for Data &amp; AI (2023)<\/strong>, MDW helps leading enterprises design, build, and operate data-driven solutions that connect <strong>Data, AI, and Business Applications<\/strong>.<\/p>\n\n\n\n<div class=\"wp-block-uagb-separator uagb-block-ba260421\"><div class=\"uagb-separator-spacing-wrapper\"><div class=\"wp-block-uagb-separator__inner\" style=\"--my-background-image:\"><\/div><\/div><\/div>\n\n\n\n<div class=\"wp-block-uagb-team uagb-team__image-position-left uagb-team__align-left uagb-team__stack-tablet uagb-block-8e99128a\"><noscript><img decoding=\"async\" class=\"uagb-team__image-crop-circle\" data-skip-lazy src=\"https:\/\/mdw-group.com\/wp-content\/uploads\/2024\/08\/Amandine-150x150.png\" alt=\"\" height=\"100\" width=\"100\" loading=\"lazy\"\/><\/noscript><img decoding=\"async\" class=\"uagb-team__image-crop-circle vp-lazyload\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMTAwIiBoZWlnaHQ9IjEwMCIgdmlld0JveD0iMCAwIDEwMCAxMDAiIGZpbGw9Im5vbmUiIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyI+PC9zdmc+\" alt height=\"100\" width=\"100\" loading=\"eager\" data-src=\"https:\/\/mdw-group.com\/wp-content\/uploads\/2024\/08\/Amandine-150x150.png\" data-sizes=\"auto\"><div class=\"uagb-team__content\"><h3 class=\"uagb-team__title\">Amandine Clauzon<\/h3><span class=\"uagb-team__prefix\">Marketing &amp; Partnerships Lead at MDW<\/span><p class=\"uagb-team__desc\"><\/p><ul class=\"uagb-team__social-list\"><li class=\"uagb-team__social-icon\"><a href=\"https:\/\/www.linkedin.com\/in\/amandine-clauzon-\/\" aria-label=\"linkedin\" target=\"_blank\" title=\"\" rel=\"noopener noreferrer\"><svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 448 512\"><path d=\"M416 32H31.9C14.3 32 0 46.5 0 64.3v383.4C0 465.5 14.3 480 31.9 480H416c17.6 0 32-14.5 32-32.3V64.3c0-17.8-14.4-32.3-32-32.3zM135.4 416H69V202.2h66.5V416zm-33.2-243c-21.3 0-38.5-17.3-38.5-38.5S80.9 96 102.2 96c21.2 0 38.5 17.3 38.5 38.5 0 21.3-17.2 38.5-38.5 38.5zm282.1 243h-66.4V312c0-24.8-.5-56.7-34.5-56.7-34.6 0-39.9 27-39.9 54.9V416h-66.4V202.2h63.7v29.2h.9c8.9-16.8 30.6-34.5 62.9-34.5 67.2 0 79.7 44.3 79.7 101.9V416z\"><\/path><\/svg><\/a><\/li><\/ul><\/div><\/div>\n\n\n\n<div class=\"wp-block-uagb-separator uagb-block-a641238f\"><div class=\"uagb-separator-spacing-wrapper\"><div class=\"wp-block-uagb-separator__inner\" style=\"--my-background-image:\"><\/div><\/div><\/div>\n\n\n\n\t\t\t<div class=\"wp-block-uagb-post-carousel uagb-post-grid  uagb-post__image-position-top uagb-post__image-enabled uagb-block-bef61616     uagb-post__arrow-outside uagb-slick-carousel uagb-post__items uagb-post__columns-3 is-carousel uagb-post__columns-tablet-2 uagb-post__columns-mobile-1 uagb-post__carousel_equal-height\" data-total=\"6\" style=\"\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t<article class=\"uagb-post__inner-wrap\">\t\t\t\t\t\t\t\t<div class='uagb-post__image'>\n\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/mdw-group.com\/es\/fy26-data-ai-adoption\/\" target=\"_self\" rel=\"bookmark noopener noreferrer\"><noscript><img decoding=\"async\" width=\"960\" height=\"720\" data-skip-lazy src=\"https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/09\/FY26-at-MDW_Data-AI-Adoption-with-Microsoft-2.png\" class=\"attachment-large size-large\" alt=\"\" srcset=\"https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/09\/FY26-at-MDW_Data-AI-Adoption-with-Microsoft-2.png 960w, https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/09\/FY26-at-MDW_Data-AI-Adoption-with-Microsoft-2-300x225.png 300w, https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/09\/FY26-at-MDW_Data-AI-Adoption-with-Microsoft-2-768x576.png 768w, https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/09\/FY26-at-MDW_Data-AI-Adoption-with-Microsoft-2-16x12.png 16w, https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/09\/FY26-at-MDW_Data-AI-Adoption-with-Microsoft-2-500x375.png 500w, https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/09\/FY26-at-MDW_Data-AI-Adoption-with-Microsoft-2-800x600.png 800w\" sizes=\"(max-width: 960px) 100vw, 960px\" \/><\/noscript><img decoding=\"async\" width=\"960\" height=\"720\" src=\"https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/09\/FY26-at-MDW_Data-AI-Adoption-with-Microsoft-2.png\" class=\"attachment-large size-large vp-lazyload\" alt srcset=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iOTYwIiBoZWlnaHQ9IjcyMCIgdmlld0JveD0iMCAwIDk2MCA3MjAiIGZpbGw9Im5vbmUiIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyI+PC9zdmc+\" data-src=\"https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/09\/FY26-at-MDW_Data-AI-Adoption-with-Microsoft-2.png\" data-srcset=\"https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/09\/FY26-at-MDW_Data-AI-Adoption-with-Microsoft-2.png 960w, https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/09\/FY26-at-MDW_Data-AI-Adoption-with-Microsoft-2-300x225.png 300w, https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/09\/FY26-at-MDW_Data-AI-Adoption-with-Microsoft-2-768x576.png 768w, https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/09\/FY26-at-MDW_Data-AI-Adoption-with-Microsoft-2-16x12.png 16w, https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/09\/FY26-at-MDW_Data-AI-Adoption-with-Microsoft-2-500x375.png 500w, https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/09\/FY26-at-MDW_Data-AI-Adoption-with-Microsoft-2-800x600.png 800w\" data-sizes=\"auto\" loading=\"eager\">\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<h6 class=\"uagb-post__title uagb-post__text\">\n\t\t\t\t<a href=\"https:\/\/mdw-group.com\/es\/fy26-data-ai-adoption\/\" target=\"_self\" rel=\"bookmark noopener noreferrer\">FY26: Our Role in Data &amp; AI Adoption with Microsoft en FY26<\/a>\n\t\t\t<\/h6>\n\t\t\t\t\t\t<div class='uagb-post__text uagb-post-grid-byline'>\n\t\t\t\t\t\t\t\t<time datetime=\"2026-09-07T09:41:38+02:00\" class=\"uagb-post__date\">\n\t\t\t\t<span class=\"dashicons-calendar dashicons\"><\/span>\t\t\t\t\tseptiembre 7, 2026\t\t\t\t<\/time>\n\t\t\t\t\t\t\t<span class=\"uagb-post__comment\">\n\t\t\t\t<span class=\"dashicons-admin-comments dashicons\"><\/span>\t\t\t\t\tNo hay comentarios\t\t\t\t<\/span>\n\t\t\t\t\t\t<\/div>\n\t\t\t\n\t\t\t\t\t\t\t\t\t<\/article>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<article class=\"uagb-post__inner-wrap\">\t\t\t\t\t\t\t\t<div class='uagb-post__image'>\n\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/mdw-group.com\/es\/fy26-data-ai-scaling-with-microsoft\/\" target=\"_self\" rel=\"bookmark noopener noreferrer\"><noscript><img decoding=\"async\" width=\"960\" height=\"720\" data-skip-lazy src=\"https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/09\/FY26-at-MDW_Scaling-Data-AI-Across-Organizations.png\" class=\"attachment-large size-large\" alt=\"MDW FY26 : Our Scaling with Microsoft\" srcset=\"https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/09\/FY26-at-MDW_Scaling-Data-AI-Across-Organizations.png 960w, https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/09\/FY26-at-MDW_Scaling-Data-AI-Across-Organizations-300x225.png 300w, https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/09\/FY26-at-MDW_Scaling-Data-AI-Across-Organizations-768x576.png 768w, https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/09\/FY26-at-MDW_Scaling-Data-AI-Across-Organizations-16x12.png 16w, https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/09\/FY26-at-MDW_Scaling-Data-AI-Across-Organizations-500x375.png 500w, https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/09\/FY26-at-MDW_Scaling-Data-AI-Across-Organizations-800x600.png 800w\" sizes=\"(max-width: 960px) 100vw, 960px\" \/><\/noscript><img decoding=\"async\" width=\"960\" height=\"720\" src=\"https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/09\/FY26-at-MDW_Scaling-Data-AI-Across-Organizations.png\" class=\"attachment-large size-large vp-lazyload\" alt=\"MDW FY26 : Our Scaling with Microsoft\" srcset=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iOTYwIiBoZWlnaHQ9IjcyMCIgdmlld0JveD0iMCAwIDk2MCA3MjAiIGZpbGw9Im5vbmUiIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyI+PC9zdmc+\" data-src=\"https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/09\/FY26-at-MDW_Scaling-Data-AI-Across-Organizations.png\" data-srcset=\"https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/09\/FY26-at-MDW_Scaling-Data-AI-Across-Organizations.png 960w, https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/09\/FY26-at-MDW_Scaling-Data-AI-Across-Organizations-300x225.png 300w, https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/09\/FY26-at-MDW_Scaling-Data-AI-Across-Organizations-768x576.png 768w, https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/09\/FY26-at-MDW_Scaling-Data-AI-Across-Organizations-16x12.png 16w, https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/09\/FY26-at-MDW_Scaling-Data-AI-Across-Organizations-500x375.png 500w, https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/09\/FY26-at-MDW_Scaling-Data-AI-Across-Organizations-800x600.png 800w\" data-sizes=\"auto\" loading=\"eager\">\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<h6 class=\"uagb-post__title uagb-post__text\">\n\t\t\t\t<a href=\"https:\/\/mdw-group.com\/es\/fy26-data-ai-scaling-with-microsoft\/\" target=\"_self\" rel=\"bookmark noopener noreferrer\">FY26 at MDW: Our Scaling with Microsoft<\/a>\n\t\t\t<\/h6>\n\t\t\t\t\t\t<div class='uagb-post__text uagb-post-grid-byline'>\n\t\t\t\t\t\t\t\t<time datetime=\"2026-09-01T14:05:00+02:00\" class=\"uagb-post__date\">\n\t\t\t\t<span class=\"dashicons-calendar dashicons\"><\/span>\t\t\t\t\tseptiembre 1, 2026\t\t\t\t<\/time>\n\t\t\t\t\t\t\t<span class=\"uagb-post__comment\">\n\t\t\t\t<span class=\"dashicons-admin-comments dashicons\"><\/span>\t\t\t\t\tNo hay comentarios\t\t\t\t<\/span>\n\t\t\t\t\t\t<\/div>\n\t\t\t\n\t\t\t\t\t\t\t\t\t<\/article>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<article class=\"uagb-post__inner-wrap\">\t\t\t\t\t\t\t\t<div class='uagb-post__image'>\n\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/mdw-group.com\/es\/simplifying-data-governance-with-unity-catalog\/\" target=\"_self\" rel=\"bookmark noopener noreferrer\"><noscript><img decoding=\"async\" width=\"960\" height=\"720\" data-skip-lazy src=\"https:\/\/mdw-group.com\/wp-content\/uploads\/2025\/07\/Blog-Post-Website.png\" class=\"attachment-large size-large\" alt=\"Simplifying Data Governance with \u000bUnity Catalog\" srcset=\"https:\/\/mdw-group.com\/wp-content\/uploads\/2025\/07\/Blog-Post-Website.png 960w, https:\/\/mdw-group.com\/wp-content\/uploads\/2025\/07\/Blog-Post-Website-300x225.png 300w, https:\/\/mdw-group.com\/wp-content\/uploads\/2025\/07\/Blog-Post-Website-768x576.png 768w, https:\/\/mdw-group.com\/wp-content\/uploads\/2025\/07\/Blog-Post-Website-500x375.png 500w, https:\/\/mdw-group.com\/wp-content\/uploads\/2025\/07\/Blog-Post-Website-800x600.png 800w\" sizes=\"(max-width: 960px) 100vw, 960px\" \/><\/noscript><img decoding=\"async\" width=\"960\" height=\"720\" src=\"https:\/\/mdw-group.com\/wp-content\/uploads\/2025\/07\/Blog-Post-Website.png\" class=\"attachment-large size-large vp-lazyload\" alt=\"Simplifying Data Governance with \u000bUnity Catalog\" srcset=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iOTYwIiBoZWlnaHQ9IjcyMCIgdmlld0JveD0iMCAwIDk2MCA3MjAiIGZpbGw9Im5vbmUiIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyI+PC9zdmc+\" data-src=\"https:\/\/mdw-group.com\/wp-content\/uploads\/2025\/07\/Blog-Post-Website.png\" data-srcset=\"https:\/\/mdw-group.com\/wp-content\/uploads\/2025\/07\/Blog-Post-Website.png 960w, https:\/\/mdw-group.com\/wp-content\/uploads\/2025\/07\/Blog-Post-Website-300x225.png 300w, https:\/\/mdw-group.com\/wp-content\/uploads\/2025\/07\/Blog-Post-Website-768x576.png 768w, https:\/\/mdw-group.com\/wp-content\/uploads\/2025\/07\/Blog-Post-Website-500x375.png 500w, https:\/\/mdw-group.com\/wp-content\/uploads\/2025\/07\/Blog-Post-Website-800x600.png 800w\" data-sizes=\"auto\" loading=\"eager\">\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<h6 class=\"uagb-post__title uagb-post__text\">\n\t\t\t\t<a href=\"https:\/\/mdw-group.com\/es\/simplifying-data-governance-with-unity-catalog\/\" target=\"_self\" rel=\"bookmark noopener noreferrer\">Simplifying Data Governance with Unity Catalog<\/a>\n\t\t\t<\/h6>\n\t\t\t\t\t\t<div class='uagb-post__text uagb-post-grid-byline'>\n\t\t\t\t\t\t\t\t<time datetime=\"2026-08-18T11:17:00+02:00\" class=\"uagb-post__date\">\n\t\t\t\t<span class=\"dashicons-calendar dashicons\"><\/span>\t\t\t\t\tagosto 18, 2026\t\t\t\t<\/time>\n\t\t\t\t\t\t\t<span class=\"uagb-post__comment\">\n\t\t\t\t<span class=\"dashicons-admin-comments dashicons\"><\/span>\t\t\t\t\tNo hay comentarios\t\t\t\t<\/span>\n\t\t\t\t\t\t<\/div>\n\t\t\t\n\t\t\t\t\t\t\t\t\t<\/article>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<article class=\"uagb-post__inner-wrap\">\t\t\t\t\t\t\t\t<div class='uagb-post__image'>\n\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/mdw-group.com\/es\/enhancing-data-governance-through-purview\/\" target=\"_self\" rel=\"bookmark noopener noreferrer\"><noscript><img decoding=\"async\" width=\"953\" height=\"720\" data-skip-lazy src=\"https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/07\/Purview-Governance.png\" class=\"attachment-large size-large\" alt=\"Enhancing Data Governance with Purview\" srcset=\"https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/07\/Purview-Governance.png 953w, https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/07\/Purview-Governance-300x227.png 300w, https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/07\/Purview-Governance-768x580.png 768w, https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/07\/Purview-Governance-500x378.png 500w, https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/07\/Purview-Governance-800x604.png 800w\" sizes=\"(max-width: 953px) 100vw, 953px\" \/><\/noscript><img decoding=\"async\" width=\"953\" height=\"720\" src=\"https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/07\/Purview-Governance.png\" class=\"attachment-large size-large vp-lazyload\" alt=\"Enhancing Data Governance with Purview\" srcset=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iOTUzIiBoZWlnaHQ9IjcyMCIgdmlld0JveD0iMCAwIDk1MyA3MjAiIGZpbGw9Im5vbmUiIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyI+PC9zdmc+\" data-src=\"https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/07\/Purview-Governance.png\" data-srcset=\"https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/07\/Purview-Governance.png 953w, https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/07\/Purview-Governance-300x227.png 300w, https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/07\/Purview-Governance-768x580.png 768w, https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/07\/Purview-Governance-500x378.png 500w, https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/07\/Purview-Governance-800x604.png 800w\" data-sizes=\"auto\" loading=\"eager\">\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<h6 class=\"uagb-post__title uagb-post__text\">\n\t\t\t\t<a href=\"https:\/\/mdw-group.com\/es\/enhancing-data-governance-through-purview\/\" target=\"_self\" rel=\"bookmark noopener noreferrer\">Enhancing Data Governance Through Purview<\/a>\n\t\t\t<\/h6>\n\t\t\t\t\t\t<div class='uagb-post__text uagb-post-grid-byline'>\n\t\t\t\t\t\t\t\t<time datetime=\"2026-07-24T09:47:00+02:00\" class=\"uagb-post__date\">\n\t\t\t\t<span class=\"dashicons-calendar dashicons\"><\/span>\t\t\t\t\tjulio 24, 2026\t\t\t\t<\/time>\n\t\t\t\t\t\t\t<span class=\"uagb-post__comment\">\n\t\t\t\t<span class=\"dashicons-admin-comments dashicons\"><\/span>\t\t\t\t\tNo hay comentarios\t\t\t\t<\/span>\n\t\t\t\t\t\t<\/div>\n\t\t\t\n\t\t\t\t\t\t\t\t\t<\/article>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<article class=\"uagb-post__inner-wrap\">\t\t\t\t\t\t\t\t<div class='uagb-post__image'>\n\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/mdw-group.com\/es\/design-in-power-bi\/\" target=\"_self\" rel=\"bookmark noopener noreferrer\"><noscript><img decoding=\"async\" width=\"953\" height=\"720\" data-skip-lazy src=\"https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/06\/Design-in-Power-BI_Blog-Post.png\" class=\"attachment-large size-large\" alt=\"Design in Power BI_Blog Post\" srcset=\"https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/06\/Design-in-Power-BI_Blog-Post.png 953w, https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/06\/Design-in-Power-BI_Blog-Post-300x227.png 300w, https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/06\/Design-in-Power-BI_Blog-Post-768x580.png 768w, https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/06\/Design-in-Power-BI_Blog-Post-500x378.png 500w, https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/06\/Design-in-Power-BI_Blog-Post-800x604.png 800w\" sizes=\"(max-width: 953px) 100vw, 953px\" \/><\/noscript><img decoding=\"async\" width=\"953\" height=\"720\" src=\"https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/06\/Design-in-Power-BI_Blog-Post.png\" class=\"attachment-large size-large vp-lazyload\" alt=\"Design in Power BI_Blog Post\" srcset=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iOTUzIiBoZWlnaHQ9IjcyMCIgdmlld0JveD0iMCAwIDk1MyA3MjAiIGZpbGw9Im5vbmUiIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyI+PC9zdmc+\" data-src=\"https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/06\/Design-in-Power-BI_Blog-Post.png\" data-srcset=\"https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/06\/Design-in-Power-BI_Blog-Post.png 953w, https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/06\/Design-in-Power-BI_Blog-Post-300x227.png 300w, https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/06\/Design-in-Power-BI_Blog-Post-768x580.png 768w, https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/06\/Design-in-Power-BI_Blog-Post-500x378.png 500w, https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/06\/Design-in-Power-BI_Blog-Post-800x604.png 800w\" data-sizes=\"auto\" loading=\"eager\">\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<h6 class=\"uagb-post__title uagb-post__text\">\n\t\t\t\t<a href=\"https:\/\/mdw-group.com\/es\/design-in-power-bi\/\" target=\"_self\" rel=\"bookmark noopener noreferrer\">Design in Power BI<\/a>\n\t\t\t<\/h6>\n\t\t\t\t\t\t<div class='uagb-post__text uagb-post-grid-byline'>\n\t\t\t\t\t\t\t\t<time datetime=\"2026-06-23T17:23:07+02:00\" class=\"uagb-post__date\">\n\t\t\t\t<span class=\"dashicons-calendar dashicons\"><\/span>\t\t\t\t\tjunio 23, 2026\t\t\t\t<\/time>\n\t\t\t\t\t\t\t<span class=\"uagb-post__comment\">\n\t\t\t\t<span class=\"dashicons-admin-comments dashicons\"><\/span>\t\t\t\t\tNo hay comentarios\t\t\t\t<\/span>\n\t\t\t\t\t\t<\/div>\n\t\t\t\n\t\t\t\t\t\t\t\t\t<\/article>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<article class=\"uagb-post__inner-wrap\">\t\t\t\t\t\t\t\t<div class='uagb-post__image'>\n\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/mdw-group.com\/es\/microsoft-copilot-studio\/\" target=\"_self\" rel=\"bookmark noopener noreferrer\"><noscript><img decoding=\"async\" width=\"953\" height=\"720\" data-skip-lazy src=\"https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/05\/Microsoft-Copilot-Studio-Website.png\" class=\"attachment-large size-large\" alt=\"\" srcset=\"https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/05\/Microsoft-Copilot-Studio-Website.png 953w, https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/05\/Microsoft-Copilot-Studio-Website-300x227.png 300w, https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/05\/Microsoft-Copilot-Studio-Website-768x580.png 768w, https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/05\/Microsoft-Copilot-Studio-Website-500x378.png 500w, https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/05\/Microsoft-Copilot-Studio-Website-800x604.png 800w\" sizes=\"(max-width: 953px) 100vw, 953px\" \/><\/noscript><img decoding=\"async\" width=\"953\" height=\"720\" src=\"https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/05\/Microsoft-Copilot-Studio-Website.png\" class=\"attachment-large size-large vp-lazyload\" alt srcset=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iOTUzIiBoZWlnaHQ9IjcyMCIgdmlld0JveD0iMCAwIDk1MyA3MjAiIGZpbGw9Im5vbmUiIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyI+PC9zdmc+\" data-src=\"https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/05\/Microsoft-Copilot-Studio-Website.png\" data-srcset=\"https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/05\/Microsoft-Copilot-Studio-Website.png 953w, https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/05\/Microsoft-Copilot-Studio-Website-300x227.png 300w, https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/05\/Microsoft-Copilot-Studio-Website-768x580.png 768w, https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/05\/Microsoft-Copilot-Studio-Website-500x378.png 500w, https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/05\/Microsoft-Copilot-Studio-Website-800x604.png 800w\" data-sizes=\"auto\" loading=\"eager\">\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<h6 class=\"uagb-post__title uagb-post__text\">\n\t\t\t\t<a href=\"https:\/\/mdw-group.com\/es\/microsoft-copilot-studio\/\" target=\"_self\" rel=\"bookmark noopener noreferrer\">Microsoft Copilot Studio<\/a>\n\t\t\t<\/h6>\n\t\t\t\t\t\t<div class='uagb-post__text uagb-post-grid-byline'>\n\t\t\t\t\t\t\t\t<time datetime=\"2026-05-27T10:54:21+02:00\" class=\"uagb-post__date\">\n\t\t\t\t<span class=\"dashicons-calendar dashicons\"><\/span>\t\t\t\t\tmayo 27, 2026\t\t\t\t<\/time>\n\t\t\t\t\t\t\t<span class=\"uagb-post__comment\">\n\t\t\t\t<span class=\"dashicons-admin-comments dashicons\"><\/span>\t\t\t\t\tNo hay comentarios\t\t\t\t<\/span>\n\t\t\t\t\t\t<\/div>\n\t\t\t\n\t\t\t\t\t\t\t\t\t<\/article>\n\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t<\/div><\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Simplify Your Power BI Reports Optimize Dynamic KPIs in Power BI with Calculation Groups Optimize Dynamic KPIs in Power BI with Calculation Groups Too Many KPIs, Too Many Measures Have you ever built a report with more than 40 KPIs? If so, you know the pain: each KPI needs its own measure plus extra calculations [&hellip;]<\/p>\n","protected":false},"author":4,"featured_media":3093,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_uag_custom_page_level_css":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"set","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"_vp_format_video_url":"","_vp_image_focal_point":[],"_vp_custom_popup_image":0,"_vp_format_audio_url":"","_vp_album_images":[],"_vp_custom_thumbnail":0,"_vp_custom_thumbnail_focal_point":[],"_vp_custom_thumbnail_cover":0,"_vp_hover_thumbnail":0,"_vp_hover_thumbnail_focal_point":[],"footnotes":""},"categories":[35],"tags":[],"class_list":["post-3086","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-blog-posts"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Simplify Your Power BI Reports - MDW<\/title>\n<meta name=\"description\" content=\"Optimize Dynamic KPIs in Power BI with Calculation Groups.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/mdw-group.com\/es\/simplify-your-power-bi-reports\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Simplify Your Power BI Reports - MDW\" \/>\n<meta property=\"og:description\" content=\"Optimize Dynamic KPIs in Power BI with Calculation Groups.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/mdw-group.com\/es\/simplify-your-power-bi-reports\/\" \/>\n<meta property=\"og:site_name\" content=\"MDW\" \/>\n<meta property=\"article:published_time\" content=\"2024-07-17T15:52:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-02-02T09:09:09+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/mdw-group.com\/wp-content\/uploads\/2024\/09\/Cover-Power-BI-Team-Website-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"960\" \/>\n\t<meta property=\"og:image:height\" content=\"720\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Amandine Clauzon\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Amandine Clauzon\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/mdw-group.com\\\/simplify-your-power-bi-reports\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/mdw-group.com\\\/simplify-your-power-bi-reports\\\/\"},\"author\":{\"name\":\"Amandine Clauzon\",\"@id\":\"https:\\\/\\\/mdw-group.com\\\/#\\\/schema\\\/person\\\/7848618d179dce9f95df45afd331740f\"},\"headline\":\"Simplify Your Power BI Reports\",\"datePublished\":\"2024-07-17T15:52:00+00:00\",\"dateModified\":\"2026-02-02T09:09:09+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/mdw-group.com\\\/simplify-your-power-bi-reports\\\/\"},\"wordCount\":1074,\"publisher\":{\"@id\":\"https:\\\/\\\/mdw-group.com\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/mdw-group.com\\\/simplify-your-power-bi-reports\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/mdw-group.com\\\/wp-content\\\/uploads\\\/2024\\\/09\\\/Cover-Power-BI-Team-Website-1.png\",\"articleSection\":[\"Blog posts\"],\"inLanguage\":\"es\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/mdw-group.com\\\/simplify-your-power-bi-reports\\\/\",\"url\":\"https:\\\/\\\/mdw-group.com\\\/simplify-your-power-bi-reports\\\/\",\"name\":\"Simplify Your Power BI Reports - MDW\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/mdw-group.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/mdw-group.com\\\/simplify-your-power-bi-reports\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/mdw-group.com\\\/simplify-your-power-bi-reports\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/mdw-group.com\\\/wp-content\\\/uploads\\\/2024\\\/09\\\/Cover-Power-BI-Team-Website-1.png\",\"datePublished\":\"2024-07-17T15:52:00+00:00\",\"dateModified\":\"2026-02-02T09:09:09+00:00\",\"description\":\"Optimize Dynamic KPIs in Power BI with Calculation Groups.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/mdw-group.com\\\/simplify-your-power-bi-reports\\\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/mdw-group.com\\\/simplify-your-power-bi-reports\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/mdw-group.com\\\/simplify-your-power-bi-reports\\\/#primaryimage\",\"url\":\"https:\\\/\\\/mdw-group.com\\\/wp-content\\\/uploads\\\/2024\\\/09\\\/Cover-Power-BI-Team-Website-1.png\",\"contentUrl\":\"https:\\\/\\\/mdw-group.com\\\/wp-content\\\/uploads\\\/2024\\\/09\\\/Cover-Power-BI-Team-Website-1.png\",\"width\":960,\"height\":720},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/mdw-group.com\\\/simplify-your-power-bi-reports\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\\\/\\\/mdw-group.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Simplify Your Power BI Reports\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/mdw-group.com\\\/#website\",\"url\":\"https:\\\/\\\/mdw-group.com\\\/\",\"name\":\"MDW group\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\\\/\\\/mdw-group.com\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/mdw-group.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/mdw-group.com\\\/#organization\",\"name\":\"MDW | My Data Works\",\"alternateName\":\"My Data Works\",\"url\":\"https:\\\/\\\/mdw-group.com\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/mdw-group.com\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/mdw-group.com\\\/wp-content\\\/uploads\\\/2026\\\/07\\\/LOGO_2025_3-color-centrado-scaled.png\",\"contentUrl\":\"https:\\\/\\\/mdw-group.com\\\/wp-content\\\/uploads\\\/2026\\\/07\\\/LOGO_2025_3-color-centrado-scaled.png\",\"width\":2560,\"height\":1336,\"caption\":\"MDW | My Data Works\"},\"image\":{\"@id\":\"https:\\\/\\\/mdw-group.com\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.linkedin.com\\\/company\\\/mdw-partners\\\/?viewAsMember=true\",\"https:\\\/\\\/www.youtube.com\\\/@mdw-my-data-works\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/mdw-group.com\\\/#\\\/schema\\\/person\\\/7848618d179dce9f95df45afd331740f\",\"name\":\"Amandine Clauzon\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1977535e90edab87a85a94c728888cd88c136460ad7b49965742f2d97ae2b871?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1977535e90edab87a85a94c728888cd88c136460ad7b49965742f2d97ae2b871?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1977535e90edab87a85a94c728888cd88c136460ad7b49965742f2d97ae2b871?s=96&d=mm&r=g\",\"caption\":\"Amandine Clauzon\"},\"url\":\"https:\\\/\\\/mdw-group.com\\\/es\\\/author\\\/amandine-clauzonmdwpartners-com\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Simplify Your Power BI Reports - MDW","description":"Optimize Dynamic KPIs in Power BI with Calculation Groups.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/mdw-group.com\/es\/simplify-your-power-bi-reports\/","og_locale":"es_ES","og_type":"article","og_title":"Simplify Your Power BI Reports - MDW","og_description":"Optimize Dynamic KPIs in Power BI with Calculation Groups.","og_url":"https:\/\/mdw-group.com\/es\/simplify-your-power-bi-reports\/","og_site_name":"MDW","article_published_time":"2024-07-17T15:52:00+00:00","article_modified_time":"2026-02-02T09:09:09+00:00","og_image":[{"width":960,"height":720,"url":"https:\/\/mdw-group.com\/wp-content\/uploads\/2024\/09\/Cover-Power-BI-Team-Website-1.png","type":"image\/png"}],"author":"Amandine Clauzon","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"Amandine Clauzon","Tiempo de lectura":"7 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/mdw-group.com\/simplify-your-power-bi-reports\/#article","isPartOf":{"@id":"https:\/\/mdw-group.com\/simplify-your-power-bi-reports\/"},"author":{"name":"Amandine Clauzon","@id":"https:\/\/mdw-group.com\/#\/schema\/person\/7848618d179dce9f95df45afd331740f"},"headline":"Simplify Your Power BI Reports","datePublished":"2024-07-17T15:52:00+00:00","dateModified":"2026-02-02T09:09:09+00:00","mainEntityOfPage":{"@id":"https:\/\/mdw-group.com\/simplify-your-power-bi-reports\/"},"wordCount":1074,"publisher":{"@id":"https:\/\/mdw-group.com\/#organization"},"image":{"@id":"https:\/\/mdw-group.com\/simplify-your-power-bi-reports\/#primaryimage"},"thumbnailUrl":"https:\/\/mdw-group.com\/wp-content\/uploads\/2024\/09\/Cover-Power-BI-Team-Website-1.png","articleSection":["Blog posts"],"inLanguage":"es"},{"@type":"WebPage","@id":"https:\/\/mdw-group.com\/simplify-your-power-bi-reports\/","url":"https:\/\/mdw-group.com\/simplify-your-power-bi-reports\/","name":"Simplify Your Power BI Reports - MDW","isPartOf":{"@id":"https:\/\/mdw-group.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/mdw-group.com\/simplify-your-power-bi-reports\/#primaryimage"},"image":{"@id":"https:\/\/mdw-group.com\/simplify-your-power-bi-reports\/#primaryimage"},"thumbnailUrl":"https:\/\/mdw-group.com\/wp-content\/uploads\/2024\/09\/Cover-Power-BI-Team-Website-1.png","datePublished":"2024-07-17T15:52:00+00:00","dateModified":"2026-02-02T09:09:09+00:00","description":"Optimize Dynamic KPIs in Power BI with Calculation Groups.","breadcrumb":{"@id":"https:\/\/mdw-group.com\/simplify-your-power-bi-reports\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/mdw-group.com\/simplify-your-power-bi-reports\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/mdw-group.com\/simplify-your-power-bi-reports\/#primaryimage","url":"https:\/\/mdw-group.com\/wp-content\/uploads\/2024\/09\/Cover-Power-BI-Team-Website-1.png","contentUrl":"https:\/\/mdw-group.com\/wp-content\/uploads\/2024\/09\/Cover-Power-BI-Team-Website-1.png","width":960,"height":720},{"@type":"BreadcrumbList","@id":"https:\/\/mdw-group.com\/simplify-your-power-bi-reports\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/mdw-group.com\/"},{"@type":"ListItem","position":2,"name":"Simplify Your Power BI Reports"}]},{"@type":"WebSite","@id":"https:\/\/mdw-group.com\/#website","url":"https:\/\/mdw-group.com\/","name":"MDW group","description":"","publisher":{"@id":"https:\/\/mdw-group.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/mdw-group.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/mdw-group.com\/#organization","name":"MDW | My Data Works","alternateName":"My Data Works","url":"https:\/\/mdw-group.com\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/mdw-group.com\/#\/schema\/logo\/image\/","url":"https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/07\/LOGO_2025_3-color-centrado-scaled.png","contentUrl":"https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/07\/LOGO_2025_3-color-centrado-scaled.png","width":2560,"height":1336,"caption":"MDW | My Data Works"},"image":{"@id":"https:\/\/mdw-group.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.linkedin.com\/company\/mdw-partners\/?viewAsMember=true","https:\/\/www.youtube.com\/@mdw-my-data-works"]},{"@type":"Person","@id":"https:\/\/mdw-group.com\/#\/schema\/person\/7848618d179dce9f95df45afd331740f","name":"Amandine Clauzon","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/secure.gravatar.com\/avatar\/1977535e90edab87a85a94c728888cd88c136460ad7b49965742f2d97ae2b871?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/1977535e90edab87a85a94c728888cd88c136460ad7b49965742f2d97ae2b871?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1977535e90edab87a85a94c728888cd88c136460ad7b49965742f2d97ae2b871?s=96&d=mm&r=g","caption":"Amandine Clauzon"},"url":"https:\/\/mdw-group.com\/es\/author\/amandine-clauzonmdwpartners-com\/"}]}},"uagb_featured_image_src":{"full":["https:\/\/mdw-group.com\/wp-content\/uploads\/2024\/09\/Cover-Power-BI-Team-Website-1.png",960,720,false],"thumbnail":["https:\/\/mdw-group.com\/wp-content\/uploads\/2024\/09\/Cover-Power-BI-Team-Website-1-150x150.png",150,150,true],"medium":["https:\/\/mdw-group.com\/wp-content\/uploads\/2024\/09\/Cover-Power-BI-Team-Website-1-300x225.png",300,225,true],"medium_large":["https:\/\/mdw-group.com\/wp-content\/uploads\/2024\/09\/Cover-Power-BI-Team-Website-1-768x576.png",768,576,true],"large":["https:\/\/mdw-group.com\/wp-content\/uploads\/2024\/09\/Cover-Power-BI-Team-Website-1.png",960,720,false],"1536x1536":["https:\/\/mdw-group.com\/wp-content\/uploads\/2024\/09\/Cover-Power-BI-Team-Website-1.png",960,720,false],"2048x2048":["https:\/\/mdw-group.com\/wp-content\/uploads\/2024\/09\/Cover-Power-BI-Team-Website-1.png",960,720,false],"trp-custom-language-flag":["https:\/\/mdw-group.com\/wp-content\/uploads\/2024\/09\/Cover-Power-BI-Team-Website-1.png",16,12,false],"vp_sm":["https:\/\/mdw-group.com\/wp-content\/uploads\/2024\/09\/Cover-Power-BI-Team-Website-1-500x375.png",500,375,true],"vp_md":["https:\/\/mdw-group.com\/wp-content\/uploads\/2024\/09\/Cover-Power-BI-Team-Website-1-800x600.png",800,600,true],"vp_lg":["https:\/\/mdw-group.com\/wp-content\/uploads\/2024\/09\/Cover-Power-BI-Team-Website-1.png",960,720,false],"vp_xl":["https:\/\/mdw-group.com\/wp-content\/uploads\/2024\/09\/Cover-Power-BI-Team-Website-1.png",960,720,false],"vp_sm_popup":["https:\/\/mdw-group.com\/wp-content\/uploads\/2024\/09\/Cover-Power-BI-Team-Website-1-500x375.png",500,375,true],"vp_md_popup":["https:\/\/mdw-group.com\/wp-content\/uploads\/2024\/09\/Cover-Power-BI-Team-Website-1-800x600.png",800,600,true],"vp_xl_popup":["https:\/\/mdw-group.com\/wp-content\/uploads\/2024\/09\/Cover-Power-BI-Team-Website-1.png",960,720,false]},"uagb_author_info":{"display_name":"Amandine Clauzon","author_link":"https:\/\/mdw-group.com\/es\/author\/amandine-clauzonmdwpartners-com\/"},"uagb_comment_info":1,"uagb_excerpt":"Simplify Your Power BI Reports Optimize Dynamic KPIs in Power BI with Calculation Groups Optimize Dynamic KPIs in Power BI with Calculation Groups Too Many KPIs, Too Many Measures Have you ever built a report with more than 40 KPIs? If so, you know the pain: each KPI needs its own measure plus extra calculations&hellip;","_links":{"self":[{"href":"https:\/\/mdw-group.com\/es\/wp-json\/wp\/v2\/posts\/3086","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mdw-group.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mdw-group.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mdw-group.com\/es\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/mdw-group.com\/es\/wp-json\/wp\/v2\/comments?post=3086"}],"version-history":[{"count":1,"href":"https:\/\/mdw-group.com\/es\/wp-json\/wp\/v2\/posts\/3086\/revisions"}],"predecessor-version":[{"id":8319,"href":"https:\/\/mdw-group.com\/es\/wp-json\/wp\/v2\/posts\/3086\/revisions\/8319"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/mdw-group.com\/es\/wp-json\/wp\/v2\/media\/3093"}],"wp:attachment":[{"href":"https:\/\/mdw-group.com\/es\/wp-json\/wp\/v2\/media?parent=3086"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mdw-group.com\/es\/wp-json\/wp\/v2\/categories?post=3086"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mdw-group.com\/es\/wp-json\/wp\/v2\/tags?post=3086"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}