{"id":3095,"date":"2024-08-21T17:58:00","date_gmt":"2024-08-21T15:58:00","guid":{"rendered":"https:\/\/dev.mdw-group.com\/?p=3095"},"modified":"2026-02-02T10:09:09","modified_gmt":"2026-02-02T09:09:09","slug":"optimize-your-power-bi-reports","status":"publish","type":"post","link":"https:\/\/mdw-group.com\/es\/optimize-your-power-bi-reports\/","title":{"rendered":"Optimiza tus Informes de Power BI: A\u00f1ade Filtros sin Comprometer el Rendimiento"},"content":{"rendered":"<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-c5ca58f0\"><h2 class=\"uagb-heading-text\">Optimiza tus Informes de Power BI: A\u00f1ade Filtros sin Comprometer el Rendimiento<\/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-08-21T17:58:00+02:00\">agosto 21, 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-c8b72b4d26e4fa8b78293e256f541a53\" style=\"color:#731373\"><strong>Add Filter Without Compromising Performance<\/strong><\/h2>\n\n\n\n<p class=\"has-ast-global-color-8-color has-text-color has-link-color wp-elements-163ada543095c74a656b6550db085b01 wp-block-paragraph\">You\u2019ve built a clean star schema in Power BI. Dimension and fact tables are linked with one-to-many, single-direction relationships. This setup makes DAX calculations efficient and easy to follow. <\/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<figure class=\"wp-block-image size-full\"><noscript><img decoding=\"async\" width=\"495\" height=\"304\" data-skip-lazy src=\"https:\/\/dev.mdw-group.com\/wp-content\/uploads\/2024\/09\/image-75.png\" alt=\"\" class=\"wp-image-3096\" srcset=\"https:\/\/mdw-group.com\/wp-content\/uploads\/2024\/09\/image-75.png 495w, https:\/\/mdw-group.com\/wp-content\/uploads\/2024\/09\/image-75-300x184.png 300w\" sizes=\"(max-width: 495px) 100vw, 495px\" \/><\/noscript><img decoding=\"async\" width=\"495\" height=\"304\" src=\"https:\/\/dev.mdw-group.com\/wp-content\/uploads\/2024\/09\/image-75.png\" alt class=\"wp-image-3096 vp-lazyload\" srcset=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iNDk1IiBoZWlnaHQ9IjMwNCIgdmlld0JveD0iMCAwIDQ5NSAzMDQiIGZpbGw9Im5vbmUiIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyI+PC9zdmc+\" data-src=\"https:\/\/dev.mdw-group.com\/wp-content\/uploads\/2024\/09\/image-75.png\" data-srcset=\"https:\/\/mdw-group.com\/wp-content\/uploads\/2024\/09\/image-75.png 495w, https:\/\/mdw-group.com\/wp-content\/uploads\/2024\/09\/image-75-300x184.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-a9aef455d5c0079f525bbb8cb9a7fc56 wp-block-paragraph\">Then the client asks for a new feature: a slicer that hides categories based on another slicer. For example, they want to see which colors were sold when filtered by size. They also want to avoid empty results when users pick invalid size\u2013color combinations.<\/p>\n\n\n\n<h2 class=\"wp-block-heading has-text-color has-link-color wp-elements-5a429436bdabce1ee5aa23fe979aa0de\" style=\"color:#731373\"><strong><strong>The first thing that comes to mind<\/strong><\/strong><\/h2>\n\n\n\n<p class=\"has-ast-global-color-8-color has-text-color has-link-color wp-elements-d870163cbb327d7f9cf21ec5eaf82468 wp-block-paragraph\">You might try switching single-direction relationships into bidirectional ones. But this breaks star schema principles for a small feature. Bidirectional filters also demand more processing and may slow down reports. Even worse, they can return unexpected results. Often, you only notice the issue once the numbers are wrong.<\/p>\n\n\n\n<h2 class=\"wp-block-heading has-text-color has-link-color wp-elements-bfb28822f5034334b929f5dabea373cc\" style=\"color:#731373\"><strong><strong>Visual-level filtering<\/strong><\/strong><\/h2>\n\n\n\n<p class=\"has-ast-global-color-8-color has-text-color has-link-color wp-elements-8b1c21073b16a1493b74f7ab0eecb86c wp-block-paragraph\">A safer option is visual-level filters. They let you control slicer behavior without touching the fact table.<br>Select the visual, open the filter pane, and apply your measure in \u201cFilters on this visual.\u201d<br>Create a measure that checks whether the size\u2013color combination exists in the fact table. For example:<\/p>\n\n\n\n<pre class=\"wp-block-code has-black-color has-text-color has-link-color wp-elements-fd524d06cc3f7a9f98b13dc4a67d6d19\"><code>Total Price = SUM ( 'FACT Sales'&#91;Price] )<\/code><\/pre>\n\n\n\n<div class=\"wp-block-uagb-separator uagb-block-b16aa27b\"><div class=\"uagb-separator-spacing-wrapper\"><div class=\"wp-block-uagb-separator__inner\" style=\"--my-background-image:\"><\/div><\/div><\/div>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><noscript><img decoding=\"async\" width=\"412\" height=\"375\" data-skip-lazy src=\"https:\/\/dev.mdw-group.com\/wp-content\/uploads\/2024\/09\/image-76.png\" alt=\"\" class=\"wp-image-3097\" style=\"width:412px;height:auto\" srcset=\"https:\/\/mdw-group.com\/wp-content\/uploads\/2024\/09\/image-76.png 412w, https:\/\/mdw-group.com\/wp-content\/uploads\/2024\/09\/image-76-300x273.png 300w\" sizes=\"(max-width: 412px) 100vw, 412px\" \/><\/noscript><img decoding=\"async\" width=\"412\" height=\"375\" src=\"https:\/\/dev.mdw-group.com\/wp-content\/uploads\/2024\/09\/image-76.png\" alt class=\"wp-image-3097 vp-lazyload\" style=\"width:412px;height:auto\" srcset=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iNDEyIiBoZWlnaHQ9IjM3NSIgdmlld0JveD0iMCAwIDQxMiAzNzUiIGZpbGw9Im5vbmUiIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyI+PC9zdmc+\" data-src=\"https:\/\/dev.mdw-group.com\/wp-content\/uploads\/2024\/09\/image-76.png\" data-srcset=\"https:\/\/mdw-group.com\/wp-content\/uploads\/2024\/09\/image-76.png 412w, https:\/\/mdw-group.com\/wp-content\/uploads\/2024\/09\/image-76-300x273.png 300w\" data-sizes=\"auto\" loading=\"eager\"><\/figure>\n\n\n\n<div class=\"wp-block-uagb-separator uagb-block-387e12c0\"><div class=\"uagb-separator-spacing-wrapper\"><div class=\"wp-block-uagb-separator__inner\" style=\"--my-background-image:\"><\/div><\/div><\/div>\n\n\n\n<p class=\"has-ast-global-color-8-color has-text-color has-link-color wp-elements-89fb19118c7821c97e0ca3ea70daf47a wp-block-paragraph\">If the result is blank, the combination doesn\u2019t exist. A simpler check is to count rows:<\/p>\n\n\n\n<pre class=\"wp-block-code has-black-color has-text-color has-link-color wp-elements-524fd538ed9bc77110f707d76886285b\"><code>Records = COUNTROWS&nbsp;( 'FACT Sales'&nbsp;)<\/code><\/pre>\n\n\n\n<p class=\"has-ast-global-color-8-color has-text-color has-link-color wp-elements-a993e311bea26ec7b43e91e9cd2429a9 wp-block-paragraph\">Apply the filter with \u201cis not blank.\u201d Now the \u201cSize\u201d slicer reacts to the \u201cColour\u201d slicer. Sizes not sold in the chosen color disappear from the list.<\/p>\n\n\n\n<div class=\"wp-block-uagb-separator uagb-block-f69286fe\"><div class=\"uagb-separator-spacing-wrapper\"><div class=\"wp-block-uagb-separator__inner\" style=\"--my-background-image:\"><\/div><\/div><\/div>\n\n\n\n<figure class=\"wp-block-image size-full\"><noscript><img decoding=\"async\" width=\"476\" height=\"337\" data-skip-lazy src=\"https:\/\/dev.mdw-group.com\/wp-content\/uploads\/2024\/09\/image-77.png\" alt=\"\" class=\"wp-image-3098\" srcset=\"https:\/\/mdw-group.com\/wp-content\/uploads\/2024\/09\/image-77.png 476w, https:\/\/mdw-group.com\/wp-content\/uploads\/2024\/09\/image-77-300x212.png 300w\" sizes=\"(max-width: 476px) 100vw, 476px\" \/><\/noscript><img decoding=\"async\" width=\"476\" height=\"337\" src=\"https:\/\/dev.mdw-group.com\/wp-content\/uploads\/2024\/09\/image-77.png\" alt class=\"wp-image-3098 vp-lazyload\" srcset=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iNDc2IiBoZWlnaHQ9IjMzNyIgdmlld0JveD0iMCAwIDQ3NiAzMzciIGZpbGw9Im5vbmUiIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyI+PC9zdmc+\" data-src=\"https:\/\/dev.mdw-group.com\/wp-content\/uploads\/2024\/09\/image-77.png\" data-srcset=\"https:\/\/mdw-group.com\/wp-content\/uploads\/2024\/09\/image-77.png 476w, https:\/\/mdw-group.com\/wp-content\/uploads\/2024\/09\/image-77-300x212.png 300w\" data-sizes=\"auto\" loading=\"eager\"><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><noscript><img decoding=\"async\" width=\"479\" height=\"150\" data-skip-lazy src=\"https:\/\/dev.mdw-group.com\/wp-content\/uploads\/2024\/09\/image-78.png\" alt=\"\" class=\"wp-image-3099\" srcset=\"https:\/\/mdw-group.com\/wp-content\/uploads\/2024\/09\/image-78.png 479w, https:\/\/mdw-group.com\/wp-content\/uploads\/2024\/09\/image-78-300x94.png 300w\" sizes=\"(max-width: 479px) 100vw, 479px\" \/><\/noscript><img decoding=\"async\" width=\"479\" height=\"150\" src=\"https:\/\/dev.mdw-group.com\/wp-content\/uploads\/2024\/09\/image-78.png\" alt class=\"wp-image-3099 vp-lazyload\" srcset=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iNDc5IiBoZWlnaHQ9IjE1MCIgdmlld0JveD0iMCAwIDQ3OSAxNTAiIGZpbGw9Im5vbmUiIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyI+PC9zdmc+\" data-src=\"https:\/\/dev.mdw-group.com\/wp-content\/uploads\/2024\/09\/image-78.png\" data-srcset=\"https:\/\/mdw-group.com\/wp-content\/uploads\/2024\/09\/image-78.png 479w, https:\/\/mdw-group.com\/wp-content\/uploads\/2024\/09\/image-78-300x94.png 300w\" data-sizes=\"auto\" loading=\"eager\"><\/figure>\n\n\n\n<h2 class=\"wp-block-heading has-text-color has-link-color wp-elements-3c01b0df4f9259d31a4605d00c0aed45\" style=\"color:#731373\"><strong><strong>Modifying relationships at run time<\/strong><\/strong><\/h2>\n\n\n\n<p class=\"has-ast-global-color-8-color has-text-color has-link-color wp-elements-21dc99ae13bb85a57f4e6b5405de2c3e wp-block-paragraph\">Sometimes the client wants dimension-to-dimension analysis. For example: how many colors were sold for each size? Normally this requires a bidirectional relationship, which can slow down large models.<br>Instead, you can use DAX to change filter direction only during query time. The <strong>CROSSFILTER<\/strong> function helps. It alters relationships only while evaluating the measure:<\/p>\n\n\n\n<pre class=\"wp-block-code has-black-color has-text-color has-link-color wp-elements-30d515eee50e692ff2a891a9f4a4970c\"><code>Different Colours Sold =\n\nCALCULATE (\n    DISTINCTCOUNT ( 'DIM Colour'&#91;Colour] ),\n    CROSSFILTER (\n        'DIM Colour'&#91;Colour],\n        'FACT Sales'&#91;Product Colour],\n        BOTH\n    )\n)<\/code><\/pre>\n\n\n\n<p class=\"has-ast-global-color-8-color has-text-color has-link-color wp-elements-9ca6d4f72f8d44229e3e433be9a23e19 wp-block-paragraph\">This counts colors in the dimension table while making the relationship bidirectional only for the measure. Place it in a table with \u201cSize\u201d and you\u2019ll see how many colors were sold for each one.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><noscript><img decoding=\"async\" width=\"195\" height=\"180\" data-skip-lazy src=\"https:\/\/dev.mdw-group.com\/wp-content\/uploads\/2024\/09\/image-79.png\" alt=\"\" class=\"wp-image-3100\"\/><\/noscript><img decoding=\"async\" width=\"195\" height=\"180\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMTk1IiBoZWlnaHQ9IjE4MCIgdmlld0JveD0iMCAwIDE5NSAxODAiIGZpbGw9Im5vbmUiIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyI+PC9zdmc+\" alt class=\"wp-image-3100 vp-lazyload\" data-src=\"https:\/\/dev.mdw-group.com\/wp-content\/uploads\/2024\/09\/image-79.png\" data-sizes=\"auto\" loading=\"eager\"><\/figure>\n\n\n\n<h2 class=\"wp-block-heading has-text-color has-link-color wp-elements-60e2bee7fcd24b840a43ec9a58080235\" style=\"color:#731373\"><strong><strong>Wrapping up<\/strong><\/strong><\/h2>\n\n\n\n<p class=\"has-ast-global-color-8-color has-text-color has-link-color wp-elements-3e64fc50ac4e43f65fdc08814afc9ffa wp-block-paragraph\">SStar schema modeling is best in almost every scenario. Don\u2019t compromise your model. Instead, use virtual relationships with functions like <strong>TREATAS<\/strong>, <strong>USERELATIONSHIP<\/strong>e <strong>INTERSECT<\/strong>. These allow targeted filtering only where needed, keeping performance high.<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=\"https:\/\/mdw-group.com\/es\/contact\/\" target=\"_blank\" rel=\"noreferrer noopener\"><u>www.mdw-group.com\/contact<\/u><\/a><\/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\">Mejorando el Gobierno de Datos con 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\">Dise\u00f1o en 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\">Uniendo Imaginaci\u00f3n e IA: El Concurso de Superh\u00e9roes y Villanos de MDW<\/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>","protected":false},"excerpt":{"rendered":"<p>Optimize Your Power BI Reports: Add Filters Without Compromising Performance Add Filter Without Compromising Performance You\u2019ve built a clean star schema in Power BI. Dimension and fact tables are linked with one-to-many, single-direction relationships. This setup makes DAX calculations efficient and easy to follow. Then the client asks for a new feature: a slicer that [&hellip;]<\/p>\n","protected":false},"author":4,"featured_media":3101,"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-3095","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>Optimize Your Power BI Reports: Add Filters Without Compromising Performance - MDW<\/title>\n<meta name=\"description\" content=\"Optimize Your Power BI Reports\" \/>\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\/optimize-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=\"Optimize Your Power BI Reports: Add Filters Without Compromising Performance - MDW\" \/>\n<meta property=\"og:description\" content=\"Optimize Your Power BI Reports\" \/>\n<meta property=\"og:url\" content=\"https:\/\/mdw-group.com\/es\/optimize-your-power-bi-reports\/\" \/>\n<meta property=\"og:site_name\" content=\"MDW\" \/>\n<meta property=\"article:published_time\" content=\"2024-08-21T15:58: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-2.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=\"4 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/mdw-group.com\\\/optimize-your-power-bi-reports\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/mdw-group.com\\\/optimize-your-power-bi-reports\\\/\"},\"author\":{\"name\":\"Amandine Clauzon\",\"@id\":\"https:\\\/\\\/mdw-group.com\\\/#\\\/schema\\\/person\\\/7848618d179dce9f95df45afd331740f\"},\"headline\":\"Optimize Your Power BI Reports: Add Filters Without Compromising Performance\",\"datePublished\":\"2024-08-21T15:58:00+00:00\",\"dateModified\":\"2026-02-02T09:09:09+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/mdw-group.com\\\/optimize-your-power-bi-reports\\\/\"},\"wordCount\":416,\"publisher\":{\"@id\":\"https:\\\/\\\/mdw-group.com\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/mdw-group.com\\\/optimize-your-power-bi-reports\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/mdw-group.com\\\/wp-content\\\/uploads\\\/2024\\\/09\\\/Cover-Power-BI-Team-Website-2.png\",\"articleSection\":[\"Blog posts\"],\"inLanguage\":\"es\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/mdw-group.com\\\/optimize-your-power-bi-reports\\\/\",\"url\":\"https:\\\/\\\/mdw-group.com\\\/optimize-your-power-bi-reports\\\/\",\"name\":\"Optimize Your Power BI Reports: Add Filters Without Compromising Performance - MDW\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/mdw-group.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/mdw-group.com\\\/optimize-your-power-bi-reports\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/mdw-group.com\\\/optimize-your-power-bi-reports\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/mdw-group.com\\\/wp-content\\\/uploads\\\/2024\\\/09\\\/Cover-Power-BI-Team-Website-2.png\",\"datePublished\":\"2024-08-21T15:58:00+00:00\",\"dateModified\":\"2026-02-02T09:09:09+00:00\",\"description\":\"Optimize Your Power BI Reports\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/mdw-group.com\\\/optimize-your-power-bi-reports\\\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/mdw-group.com\\\/optimize-your-power-bi-reports\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/mdw-group.com\\\/optimize-your-power-bi-reports\\\/#primaryimage\",\"url\":\"https:\\\/\\\/mdw-group.com\\\/wp-content\\\/uploads\\\/2024\\\/09\\\/Cover-Power-BI-Team-Website-2.png\",\"contentUrl\":\"https:\\\/\\\/mdw-group.com\\\/wp-content\\\/uploads\\\/2024\\\/09\\\/Cover-Power-BI-Team-Website-2.png\",\"width\":960,\"height\":720},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/mdw-group.com\\\/optimize-your-power-bi-reports\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\\\/\\\/mdw-group.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Optimize Your Power BI Reports: Add Filters Without Compromising Performance\"}]},{\"@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":"Optimize Your Power BI Reports: Add Filters Without Compromising Performance - MDW","description":"Optimize Your Power BI Reports","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\/optimize-your-power-bi-reports\/","og_locale":"es_ES","og_type":"article","og_title":"Optimize Your Power BI Reports: Add Filters Without Compromising Performance - MDW","og_description":"Optimize Your Power BI Reports","og_url":"https:\/\/mdw-group.com\/es\/optimize-your-power-bi-reports\/","og_site_name":"MDW","article_published_time":"2024-08-21T15:58: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-2.png","type":"image\/png"}],"author":"Amandine Clauzon","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"Amandine Clauzon","Tiempo de lectura":"4 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/mdw-group.com\/optimize-your-power-bi-reports\/#article","isPartOf":{"@id":"https:\/\/mdw-group.com\/optimize-your-power-bi-reports\/"},"author":{"name":"Amandine Clauzon","@id":"https:\/\/mdw-group.com\/#\/schema\/person\/7848618d179dce9f95df45afd331740f"},"headline":"Optimize Your Power BI Reports: Add Filters Without Compromising Performance","datePublished":"2024-08-21T15:58:00+00:00","dateModified":"2026-02-02T09:09:09+00:00","mainEntityOfPage":{"@id":"https:\/\/mdw-group.com\/optimize-your-power-bi-reports\/"},"wordCount":416,"publisher":{"@id":"https:\/\/mdw-group.com\/#organization"},"image":{"@id":"https:\/\/mdw-group.com\/optimize-your-power-bi-reports\/#primaryimage"},"thumbnailUrl":"https:\/\/mdw-group.com\/wp-content\/uploads\/2024\/09\/Cover-Power-BI-Team-Website-2.png","articleSection":["Blog posts"],"inLanguage":"es"},{"@type":"WebPage","@id":"https:\/\/mdw-group.com\/optimize-your-power-bi-reports\/","url":"https:\/\/mdw-group.com\/optimize-your-power-bi-reports\/","name":"Optimize Your Power BI Reports: Add Filters Without Compromising Performance - MDW","isPartOf":{"@id":"https:\/\/mdw-group.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/mdw-group.com\/optimize-your-power-bi-reports\/#primaryimage"},"image":{"@id":"https:\/\/mdw-group.com\/optimize-your-power-bi-reports\/#primaryimage"},"thumbnailUrl":"https:\/\/mdw-group.com\/wp-content\/uploads\/2024\/09\/Cover-Power-BI-Team-Website-2.png","datePublished":"2024-08-21T15:58:00+00:00","dateModified":"2026-02-02T09:09:09+00:00","description":"Optimize Your Power BI Reports","breadcrumb":{"@id":"https:\/\/mdw-group.com\/optimize-your-power-bi-reports\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/mdw-group.com\/optimize-your-power-bi-reports\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/mdw-group.com\/optimize-your-power-bi-reports\/#primaryimage","url":"https:\/\/mdw-group.com\/wp-content\/uploads\/2024\/09\/Cover-Power-BI-Team-Website-2.png","contentUrl":"https:\/\/mdw-group.com\/wp-content\/uploads\/2024\/09\/Cover-Power-BI-Team-Website-2.png","width":960,"height":720},{"@type":"BreadcrumbList","@id":"https:\/\/mdw-group.com\/optimize-your-power-bi-reports\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/mdw-group.com\/"},{"@type":"ListItem","position":2,"name":"Optimize Your Power BI Reports: Add Filters Without Compromising Performance"}]},{"@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-2.png",960,720,false],"thumbnail":["https:\/\/mdw-group.com\/wp-content\/uploads\/2024\/09\/Cover-Power-BI-Team-Website-2-150x150.png",150,150,true],"medium":["https:\/\/mdw-group.com\/wp-content\/uploads\/2024\/09\/Cover-Power-BI-Team-Website-2-300x225.png",300,225,true],"medium_large":["https:\/\/mdw-group.com\/wp-content\/uploads\/2024\/09\/Cover-Power-BI-Team-Website-2-768x576.png",768,576,true],"large":["https:\/\/mdw-group.com\/wp-content\/uploads\/2024\/09\/Cover-Power-BI-Team-Website-2.png",960,720,false],"1536x1536":["https:\/\/mdw-group.com\/wp-content\/uploads\/2024\/09\/Cover-Power-BI-Team-Website-2.png",960,720,false],"2048x2048":["https:\/\/mdw-group.com\/wp-content\/uploads\/2024\/09\/Cover-Power-BI-Team-Website-2.png",960,720,false],"trp-custom-language-flag":["https:\/\/mdw-group.com\/wp-content\/uploads\/2024\/09\/Cover-Power-BI-Team-Website-2.png",16,12,false],"vp_sm":["https:\/\/mdw-group.com\/wp-content\/uploads\/2024\/09\/Cover-Power-BI-Team-Website-2-500x375.png",500,375,true],"vp_md":["https:\/\/mdw-group.com\/wp-content\/uploads\/2024\/09\/Cover-Power-BI-Team-Website-2-800x600.png",800,600,true],"vp_lg":["https:\/\/mdw-group.com\/wp-content\/uploads\/2024\/09\/Cover-Power-BI-Team-Website-2.png",960,720,false],"vp_xl":["https:\/\/mdw-group.com\/wp-content\/uploads\/2024\/09\/Cover-Power-BI-Team-Website-2.png",960,720,false],"vp_sm_popup":["https:\/\/mdw-group.com\/wp-content\/uploads\/2024\/09\/Cover-Power-BI-Team-Website-2-500x375.png",500,375,true],"vp_md_popup":["https:\/\/mdw-group.com\/wp-content\/uploads\/2024\/09\/Cover-Power-BI-Team-Website-2-800x600.png",800,600,true],"vp_xl_popup":["https:\/\/mdw-group.com\/wp-content\/uploads\/2024\/09\/Cover-Power-BI-Team-Website-2.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":6,"uagb_excerpt":"Optimize Your Power BI Reports: Add Filters Without Compromising Performance Add Filter Without Compromising Performance You\u2019ve built a clean star schema in Power BI. Dimension and fact tables are linked with one-to-many, single-direction relationships. This setup makes DAX calculations efficient and easy to follow. Then the client asks for a new feature: a slicer that&hellip;","_links":{"self":[{"href":"https:\/\/mdw-group.com\/es\/wp-json\/wp\/v2\/posts\/3095","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=3095"}],"version-history":[{"count":1,"href":"https:\/\/mdw-group.com\/es\/wp-json\/wp\/v2\/posts\/3095\/revisions"}],"predecessor-version":[{"id":8318,"href":"https:\/\/mdw-group.com\/es\/wp-json\/wp\/v2\/posts\/3095\/revisions\/8318"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/mdw-group.com\/es\/wp-json\/wp\/v2\/media\/3101"}],"wp:attachment":[{"href":"https:\/\/mdw-group.com\/es\/wp-json\/wp\/v2\/media?parent=3095"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mdw-group.com\/es\/wp-json\/wp\/v2\/categories?post=3095"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mdw-group.com\/es\/wp-json\/wp\/v2\/tags?post=3095"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}