{"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-6061b6409976b01ad391f521bba2dc9a\" 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-ea16984523a13fd7e9d6dbe9ce691a3c 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-72498221cb63224a1692b521eab53b27\" 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-34574d470dd7628e36d30c93300a46a7 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-07670eb78765fb38afa91183316cab50\" 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-ae59c49b54cbe75af5739fe3b08bf8d0 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-69ad3ffba91865bc92f2cf7dde513863\" 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-6cca2aed137b91e146e5e1b2f5510ab7 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-7617e921b885ec7331c8cb49385f13fa\" 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-ad16ccc04bb3be4d728303760490dacf\">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-c9994ff6045269c485ab6d3ed9810e4b\">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-5dd5c7d8b69e2ca451a1d15316f5144e\">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-10643d7c4ce7c163c3bafb07a9160566\" 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-b3d6a5ccef369cb2f9148aea274f2a95 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-a24bb7c4f38a45e59ec9160e6a4a72b5\"><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-617b2902106ee9670b705725777cdc26\">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-e43a10dd9f2a5629bccff77c9ce0653e\" 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-cd431bde6ff2574e842a2674bacf5f28 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-f55ddc2eb360dd3ad66503cdd709b26b\" 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-0dc2a72612c69c86f94acd75f27867a9 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-45ef29d5338114477392c6d46c675214\" 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-2c81d1b5640c04d331854f56ddf67b63 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-00f553bba32cb6ec36b78a001a54cad2\" 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-6ded68eaf7182e7e6515520af0898d25 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-6e9e3b8a1c74cd2b61926b04300a2a8d\" 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-a8906ae2973af63a3aa82af4b9bc0a59 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-78f76d1dfb5f80087be495c265a574b8 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-0533152382f134739b39ee27aa9e2d75\" 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-655087e07d8ecbbbf9d7cb61d841fc16 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-e109e2663b66fc0e64d80ea928c827f7\" 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-5f10adf1007e94914b618dde3789107e 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-b5b6054965dfeb307290ff3d549e529f\" 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-b47b523c5d558b4ecfbf85c0b4638b21 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-ecafdfdd25c3028fac9fc49e55f4202e 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-9ce652db98f8d37d149a665ccb6c1efa\" 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-3cb24b8d8e0aae36de5276ff810e2889 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-2d94d165d5cffa36bc6003de9844af33\" 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-6a9a7cd713fbaf38c49daebe84eecbd7 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-fa20089d579311692747150e1331b577\" 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-0dbbe029b8dafdac3782cbea384bc716\" 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-96b18a2233a87443cbd279d3268f949b 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-969b85f7c6ddf92bd5091a3cbb3860a1\" 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-16ed613d2ce3d2a380dbbe946f996738 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-7fa72df534a760a250babeeaa2dd6b2b 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-589fb5cd063c9e2bc1a2dcbe2aa4e41a 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-b7c45bc6355d0a6da6a0d516f6c072fb\">\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-07f8f6613f8681075b9712bf8c785005 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-a388fb8cf8713afc87fecf9d573a5771\" 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-9d1a9599486f3ecaa1b3098356d2f503 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-63ee6bd6a8780e79c2cdf8b99844f114\">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-f26d6f1541f61845eeee3f48d2537bb0\">Red for negative.<\/li>\n\n\n\n<li class=\"has-ast-global-color-7-color has-text-color has-link-color wp-elements-d5f12044174a7958319fbe4847fa01c9\">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-8c912aa2265f3914402a0c2fcc49f3a8 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-74bdaccca4feb58816a2a666d8085827\" 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-a489eb760162cf635fb800a935c59c4a 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-c15af19038acfaff1904ec899db73f27\">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-612b1142c814c1e5426dade46eefc55f\">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-1aa945847bfe66969bc027c720d70e82\">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-557f4c79e19fe4d687f232abdf731a82 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-9cfe6b575414bb0cc6d8990bfc65546e\" 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-f87d5a6b56457dc184a337208f6a2d70 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=\"5\" 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\/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\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-365-e7-frontier-suite\/\" 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\/03\/Image-Website-1.png\" class=\"attachment-large size-large\" alt=\"The Frontier Suite\" srcset=\"https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/03\/Image-Website-1.png 953w, https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/03\/Image-Website-1-300x227.png 300w, https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/03\/Image-Website-1-768x580.png 768w, https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/03\/Image-Website-1-500x378.png 500w, https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/03\/Image-Website-1-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\/03\/Image-Website-1.png\" class=\"attachment-large size-large vp-lazyload\" alt=\"The Frontier Suite\" srcset=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iOTUzIiBoZWlnaHQ9IjcyMCIgdmlld0JveD0iMCAwIDk1MyA3MjAiIGZpbGw9Im5vbmUiIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyI+PC9zdmc+\" data-src=\"https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/03\/Image-Website-1.png\" data-srcset=\"https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/03\/Image-Website-1.png 953w, https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/03\/Image-Website-1-300x227.png 300w, https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/03\/Image-Website-1-768x580.png 768w, https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/03\/Image-Website-1-500x378.png 500w, https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/03\/Image-Website-1-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-365-e7-frontier-suite\/\" target=\"_self\" rel=\"bookmark noopener noreferrer\">Microsoft 365 E7<\/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-04-08T19:17:53+02:00\" class=\"uagb-post__date\">\n\t\t\t\t<span class=\"dashicons-calendar dashicons\"><\/span>\t\t\t\t\tabril 8, 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-fabric-featured-partner\/\" target=\"_self\" rel=\"bookmark noopener noreferrer\"><noscript><img decoding=\"async\" width=\"1024\" height=\"768\" data-skip-lazy src=\"https:\/\/mdw-group.com\/wp-content\/uploads\/2025\/10\/Blog-Post-Website-1024x768.png\" class=\"attachment-large size-large\" alt=\"\" srcset=\"https:\/\/mdw-group.com\/wp-content\/uploads\/2025\/10\/Blog-Post-Website-1024x768.png 1024w, https:\/\/mdw-group.com\/wp-content\/uploads\/2025\/10\/Blog-Post-Website-300x225.png 300w, https:\/\/mdw-group.com\/wp-content\/uploads\/2025\/10\/Blog-Post-Website-768x576.png 768w, https:\/\/mdw-group.com\/wp-content\/uploads\/2025\/10\/Blog-Post-Website-1536x1152.png 1536w, https:\/\/mdw-group.com\/wp-content\/uploads\/2025\/10\/Blog-Post-Website-2048x1536.png 2048w, https:\/\/mdw-group.com\/wp-content\/uploads\/2025\/10\/Blog-Post-Website-500x375.png 500w, https:\/\/mdw-group.com\/wp-content\/uploads\/2025\/10\/Blog-Post-Website-800x600.png 800w, https:\/\/mdw-group.com\/wp-content\/uploads\/2025\/10\/Blog-Post-Website-1280x960.png 1280w, https:\/\/mdw-group.com\/wp-content\/uploads\/2025\/10\/Blog-Post-Website-1920x1440.png 1920w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/noscript><img decoding=\"async\" width=\"1024\" height=\"768\" src=\"https:\/\/mdw-group.com\/wp-content\/uploads\/2025\/10\/Blog-Post-Website-1024x768.png\" class=\"attachment-large size-large vp-lazyload\" alt srcset=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMTAyNCIgaGVpZ2h0PSI3NjgiIHZpZXdCb3g9IjAgMCAxMDI0IDc2OCIgZmlsbD0ibm9uZSIgeG1sbnM9Imh0dHA6Ly93d3cudzMub3JnLzIwMDAvc3ZnIj48L3N2Zz4=\" data-src=\"https:\/\/mdw-group.com\/wp-content\/uploads\/2025\/10\/Blog-Post-Website-1024x768.png\" data-srcset=\"https:\/\/mdw-group.com\/wp-content\/uploads\/2025\/10\/Blog-Post-Website-1024x768.png 1024w, https:\/\/mdw-group.com\/wp-content\/uploads\/2025\/10\/Blog-Post-Website-300x225.png 300w, https:\/\/mdw-group.com\/wp-content\/uploads\/2025\/10\/Blog-Post-Website-768x576.png 768w, https:\/\/mdw-group.com\/wp-content\/uploads\/2025\/10\/Blog-Post-Website-1536x1152.png 1536w, https:\/\/mdw-group.com\/wp-content\/uploads\/2025\/10\/Blog-Post-Website-2048x1536.png 2048w, https:\/\/mdw-group.com\/wp-content\/uploads\/2025\/10\/Blog-Post-Website-500x375.png 500w, https:\/\/mdw-group.com\/wp-content\/uploads\/2025\/10\/Blog-Post-Website-800x600.png 800w, https:\/\/mdw-group.com\/wp-content\/uploads\/2025\/10\/Blog-Post-Website-1280x960.png 1280w, https:\/\/mdw-group.com\/wp-content\/uploads\/2025\/10\/Blog-Post-Website-1920x1440.png 1920w\" 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-fabric-featured-partner\/\" target=\"_self\" rel=\"bookmark noopener noreferrer\">Microsoft Fabric Featured Partner<\/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=\"2025-10-16T10:35:45+02:00\" class=\"uagb-post__date\">\n\t\t\t\t<span class=\"dashicons-calendar dashicons\"><\/span>\t\t\t\t\toctubre 16, 2025\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\/superheroes-villains-creation-contest-powered-by-ai\/\" target=\"_self\" rel=\"bookmark noopener noreferrer\"><noscript><img decoding=\"async\" width=\"1024\" height=\"768\" data-skip-lazy src=\"https:\/\/mdw-group.com\/wp-content\/uploads\/2025\/09\/Blog-Post-Website-1024x768.png\" class=\"attachment-large size-large\" alt=\"\" srcset=\"https:\/\/mdw-group.com\/wp-content\/uploads\/2025\/09\/Blog-Post-Website-1024x768.png 1024w, https:\/\/mdw-group.com\/wp-content\/uploads\/2025\/09\/Blog-Post-Website-300x225.png 300w, https:\/\/mdw-group.com\/wp-content\/uploads\/2025\/09\/Blog-Post-Website-768x576.png 768w, https:\/\/mdw-group.com\/wp-content\/uploads\/2025\/09\/Blog-Post-Website-1536x1152.png 1536w, https:\/\/mdw-group.com\/wp-content\/uploads\/2025\/09\/Blog-Post-Website-2048x1536.png 2048w, https:\/\/mdw-group.com\/wp-content\/uploads\/2025\/09\/Blog-Post-Website-500x375.png 500w, https:\/\/mdw-group.com\/wp-content\/uploads\/2025\/09\/Blog-Post-Website-800x600.png 800w, https:\/\/mdw-group.com\/wp-content\/uploads\/2025\/09\/Blog-Post-Website-1280x960.png 1280w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/noscript><img decoding=\"async\" width=\"1024\" height=\"768\" src=\"https:\/\/mdw-group.com\/wp-content\/uploads\/2025\/09\/Blog-Post-Website-1024x768.png\" class=\"attachment-large size-large vp-lazyload\" alt srcset=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMTAyNCIgaGVpZ2h0PSI3NjgiIHZpZXdCb3g9IjAgMCAxMDI0IDc2OCIgZmlsbD0ibm9uZSIgeG1sbnM9Imh0dHA6Ly93d3cudzMub3JnLzIwMDAvc3ZnIj48L3N2Zz4=\" data-src=\"https:\/\/mdw-group.com\/wp-content\/uploads\/2025\/09\/Blog-Post-Website-1024x768.png\" data-srcset=\"https:\/\/mdw-group.com\/wp-content\/uploads\/2025\/09\/Blog-Post-Website-1024x768.png 1024w, https:\/\/mdw-group.com\/wp-content\/uploads\/2025\/09\/Blog-Post-Website-300x225.png 300w, https:\/\/mdw-group.com\/wp-content\/uploads\/2025\/09\/Blog-Post-Website-768x576.png 768w, https:\/\/mdw-group.com\/wp-content\/uploads\/2025\/09\/Blog-Post-Website-1536x1152.png 1536w, https:\/\/mdw-group.com\/wp-content\/uploads\/2025\/09\/Blog-Post-Website-2048x1536.png 2048w, https:\/\/mdw-group.com\/wp-content\/uploads\/2025\/09\/Blog-Post-Website-500x375.png 500w, https:\/\/mdw-group.com\/wp-content\/uploads\/2025\/09\/Blog-Post-Website-800x600.png 800w, https:\/\/mdw-group.com\/wp-content\/uploads\/2025\/09\/Blog-Post-Website-1280x960.png 1280w\" 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\/superheroes-villains-creation-contest-powered-by-ai\/\" target=\"_self\" rel=\"bookmark noopener noreferrer\">Blending Imagination and AI: MDW\u2019s Superheroes &amp; Villains Contest<\/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=\"2025-09-30T12:36:57+02:00\" class=\"uagb-post__date\">\n\t\t\t\t<span class=\"dashicons-calendar dashicons\"><\/span>\t\t\t\t\tseptiembre 30, 2025\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.3 - 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}]}}