{"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-1\" 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-2 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-3 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-4\" 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-5 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-6\" 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-7 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-8\"><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-9 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-10\"><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-11 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-12\" 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-13 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-14\"><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-15 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-16\" 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-17 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=\"6\" style=\"\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t<article class=\"uagb-post__inner-wrap\">\t\t\t\t\t\t\t\t<div class='uagb-post__image'>\n\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/mdw-group.com\/es\/fy26-data-ai-adoption\/\" target=\"_self\" rel=\"bookmark noopener noreferrer\"><noscript><img decoding=\"async\" width=\"960\" height=\"720\" data-skip-lazy src=\"https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/09\/FY26-at-MDW_Data-AI-Adoption-with-Microsoft-2.png\" class=\"attachment-large size-large\" alt=\"\" srcset=\"https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/09\/FY26-at-MDW_Data-AI-Adoption-with-Microsoft-2.png 960w, https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/09\/FY26-at-MDW_Data-AI-Adoption-with-Microsoft-2-300x225.png 300w, https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/09\/FY26-at-MDW_Data-AI-Adoption-with-Microsoft-2-768x576.png 768w, https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/09\/FY26-at-MDW_Data-AI-Adoption-with-Microsoft-2-16x12.png 16w, https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/09\/FY26-at-MDW_Data-AI-Adoption-with-Microsoft-2-500x375.png 500w, https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/09\/FY26-at-MDW_Data-AI-Adoption-with-Microsoft-2-800x600.png 800w\" sizes=\"(max-width: 960px) 100vw, 960px\" \/><\/noscript><img decoding=\"async\" width=\"960\" height=\"720\" src=\"https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/09\/FY26-at-MDW_Data-AI-Adoption-with-Microsoft-2.png\" class=\"attachment-large size-large vp-lazyload\" alt srcset=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iOTYwIiBoZWlnaHQ9IjcyMCIgdmlld0JveD0iMCAwIDk2MCA3MjAiIGZpbGw9Im5vbmUiIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyI+PC9zdmc+\" data-src=\"https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/09\/FY26-at-MDW_Data-AI-Adoption-with-Microsoft-2.png\" data-srcset=\"https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/09\/FY26-at-MDW_Data-AI-Adoption-with-Microsoft-2.png 960w, https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/09\/FY26-at-MDW_Data-AI-Adoption-with-Microsoft-2-300x225.png 300w, https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/09\/FY26-at-MDW_Data-AI-Adoption-with-Microsoft-2-768x576.png 768w, https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/09\/FY26-at-MDW_Data-AI-Adoption-with-Microsoft-2-16x12.png 16w, https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/09\/FY26-at-MDW_Data-AI-Adoption-with-Microsoft-2-500x375.png 500w, https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/09\/FY26-at-MDW_Data-AI-Adoption-with-Microsoft-2-800x600.png 800w\" data-sizes=\"auto\" loading=\"eager\">\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<h6 class=\"uagb-post__title uagb-post__text\">\n\t\t\t\t<a href=\"https:\/\/mdw-group.com\/es\/fy26-data-ai-adoption\/\" target=\"_self\" rel=\"bookmark noopener noreferrer\">FY26: Our Role in Data &amp; AI Adoption with Microsoft en FY26<\/a>\n\t\t\t<\/h6>\n\t\t\t\t\t\t<div class='uagb-post__text uagb-post-grid-byline'>\n\t\t\t\t\t\t\t\t<time datetime=\"2026-09-07T09:41:38+02:00\" class=\"uagb-post__date\">\n\t\t\t\t<span class=\"dashicons-calendar dashicons\"><\/span>\t\t\t\t\tseptiembre 7, 2026\t\t\t\t<\/time>\n\t\t\t\t\t\t\t<span class=\"uagb-post__comment\">\n\t\t\t\t<span class=\"dashicons-admin-comments dashicons\"><\/span>\t\t\t\t\tNo hay comentarios\t\t\t\t<\/span>\n\t\t\t\t\t\t<\/div>\n\t\t\t\n\t\t\t\t\t\t\t\t\t<\/article>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<article class=\"uagb-post__inner-wrap\">\t\t\t\t\t\t\t\t<div class='uagb-post__image'>\n\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/mdw-group.com\/es\/fy26-data-ai-scaling-with-microsoft\/\" target=\"_self\" rel=\"bookmark noopener noreferrer\"><noscript><img decoding=\"async\" width=\"960\" height=\"720\" data-skip-lazy src=\"https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/09\/FY26-at-MDW_Scaling-Data-AI-Across-Organizations.png\" class=\"attachment-large size-large\" alt=\"MDW FY26 : Our Scaling with Microsoft\" srcset=\"https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/09\/FY26-at-MDW_Scaling-Data-AI-Across-Organizations.png 960w, https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/09\/FY26-at-MDW_Scaling-Data-AI-Across-Organizations-300x225.png 300w, https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/09\/FY26-at-MDW_Scaling-Data-AI-Across-Organizations-768x576.png 768w, https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/09\/FY26-at-MDW_Scaling-Data-AI-Across-Organizations-16x12.png 16w, https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/09\/FY26-at-MDW_Scaling-Data-AI-Across-Organizations-500x375.png 500w, https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/09\/FY26-at-MDW_Scaling-Data-AI-Across-Organizations-800x600.png 800w\" sizes=\"(max-width: 960px) 100vw, 960px\" \/><\/noscript><img decoding=\"async\" width=\"960\" height=\"720\" src=\"https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/09\/FY26-at-MDW_Scaling-Data-AI-Across-Organizations.png\" class=\"attachment-large size-large vp-lazyload\" alt=\"MDW FY26 : Our Scaling with Microsoft\" srcset=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iOTYwIiBoZWlnaHQ9IjcyMCIgdmlld0JveD0iMCAwIDk2MCA3MjAiIGZpbGw9Im5vbmUiIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyI+PC9zdmc+\" data-src=\"https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/09\/FY26-at-MDW_Scaling-Data-AI-Across-Organizations.png\" data-srcset=\"https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/09\/FY26-at-MDW_Scaling-Data-AI-Across-Organizations.png 960w, https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/09\/FY26-at-MDW_Scaling-Data-AI-Across-Organizations-300x225.png 300w, https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/09\/FY26-at-MDW_Scaling-Data-AI-Across-Organizations-768x576.png 768w, https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/09\/FY26-at-MDW_Scaling-Data-AI-Across-Organizations-16x12.png 16w, https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/09\/FY26-at-MDW_Scaling-Data-AI-Across-Organizations-500x375.png 500w, https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/09\/FY26-at-MDW_Scaling-Data-AI-Across-Organizations-800x600.png 800w\" data-sizes=\"auto\" loading=\"eager\">\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<h6 class=\"uagb-post__title uagb-post__text\">\n\t\t\t\t<a href=\"https:\/\/mdw-group.com\/es\/fy26-data-ai-scaling-with-microsoft\/\" target=\"_self\" rel=\"bookmark noopener noreferrer\">FY26 at MDW: Our Scaling with Microsoft<\/a>\n\t\t\t<\/h6>\n\t\t\t\t\t\t<div class='uagb-post__text uagb-post-grid-byline'>\n\t\t\t\t\t\t\t\t<time datetime=\"2026-09-01T14:05:00+02:00\" class=\"uagb-post__date\">\n\t\t\t\t<span class=\"dashicons-calendar dashicons\"><\/span>\t\t\t\t\tseptiembre 1, 2026\t\t\t\t<\/time>\n\t\t\t\t\t\t\t<span class=\"uagb-post__comment\">\n\t\t\t\t<span class=\"dashicons-admin-comments dashicons\"><\/span>\t\t\t\t\tNo hay comentarios\t\t\t\t<\/span>\n\t\t\t\t\t\t<\/div>\n\t\t\t\n\t\t\t\t\t\t\t\t\t<\/article>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<article class=\"uagb-post__inner-wrap\">\t\t\t\t\t\t\t\t<div class='uagb-post__image'>\n\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/mdw-group.com\/es\/simplifying-data-governance-with-unity-catalog\/\" target=\"_self\" rel=\"bookmark noopener noreferrer\"><noscript><img decoding=\"async\" width=\"960\" height=\"720\" data-skip-lazy src=\"https:\/\/mdw-group.com\/wp-content\/uploads\/2025\/07\/Blog-Post-Website.png\" class=\"attachment-large size-large\" alt=\"Simplifying Data Governance with \u000bUnity Catalog\" srcset=\"https:\/\/mdw-group.com\/wp-content\/uploads\/2025\/07\/Blog-Post-Website.png 960w, https:\/\/mdw-group.com\/wp-content\/uploads\/2025\/07\/Blog-Post-Website-300x225.png 300w, https:\/\/mdw-group.com\/wp-content\/uploads\/2025\/07\/Blog-Post-Website-768x576.png 768w, https:\/\/mdw-group.com\/wp-content\/uploads\/2025\/07\/Blog-Post-Website-500x375.png 500w, https:\/\/mdw-group.com\/wp-content\/uploads\/2025\/07\/Blog-Post-Website-800x600.png 800w\" sizes=\"(max-width: 960px) 100vw, 960px\" \/><\/noscript><img decoding=\"async\" width=\"960\" height=\"720\" src=\"https:\/\/mdw-group.com\/wp-content\/uploads\/2025\/07\/Blog-Post-Website.png\" class=\"attachment-large size-large vp-lazyload\" alt=\"Simplifying Data Governance with \u000bUnity Catalog\" srcset=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iOTYwIiBoZWlnaHQ9IjcyMCIgdmlld0JveD0iMCAwIDk2MCA3MjAiIGZpbGw9Im5vbmUiIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyI+PC9zdmc+\" data-src=\"https:\/\/mdw-group.com\/wp-content\/uploads\/2025\/07\/Blog-Post-Website.png\" data-srcset=\"https:\/\/mdw-group.com\/wp-content\/uploads\/2025\/07\/Blog-Post-Website.png 960w, https:\/\/mdw-group.com\/wp-content\/uploads\/2025\/07\/Blog-Post-Website-300x225.png 300w, https:\/\/mdw-group.com\/wp-content\/uploads\/2025\/07\/Blog-Post-Website-768x576.png 768w, https:\/\/mdw-group.com\/wp-content\/uploads\/2025\/07\/Blog-Post-Website-500x375.png 500w, https:\/\/mdw-group.com\/wp-content\/uploads\/2025\/07\/Blog-Post-Website-800x600.png 800w\" data-sizes=\"auto\" loading=\"eager\">\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<h6 class=\"uagb-post__title uagb-post__text\">\n\t\t\t\t<a href=\"https:\/\/mdw-group.com\/es\/simplifying-data-governance-with-unity-catalog\/\" target=\"_self\" rel=\"bookmark noopener noreferrer\">Simplificando el Gobierno de Datos con Unity Catalog<\/a>\n\t\t\t<\/h6>\n\t\t\t\t\t\t<div class='uagb-post__text uagb-post-grid-byline'>\n\t\t\t\t\t\t\t\t<time datetime=\"2026-08-18T11:17:00+02:00\" class=\"uagb-post__date\">\n\t\t\t\t<span class=\"dashicons-calendar dashicons\"><\/span>\t\t\t\t\tagosto 18, 2026\t\t\t\t<\/time>\n\t\t\t\t\t\t\t<span class=\"uagb-post__comment\">\n\t\t\t\t<span class=\"dashicons-admin-comments dashicons\"><\/span>\t\t\t\t\tNo hay comentarios\t\t\t\t<\/span>\n\t\t\t\t\t\t<\/div>\n\t\t\t\n\t\t\t\t\t\t\t\t\t<\/article>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<article class=\"uagb-post__inner-wrap\">\t\t\t\t\t\t\t\t<div class='uagb-post__image'>\n\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/mdw-group.com\/es\/enhancing-data-governance-through-purview\/\" target=\"_self\" rel=\"bookmark noopener noreferrer\"><noscript><img decoding=\"async\" width=\"953\" height=\"720\" data-skip-lazy src=\"https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/07\/Purview-Governance.png\" class=\"attachment-large size-large\" alt=\"Enhancing Data Governance with Purview\" srcset=\"https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/07\/Purview-Governance.png 953w, https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/07\/Purview-Governance-300x227.png 300w, https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/07\/Purview-Governance-768x580.png 768w, https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/07\/Purview-Governance-500x378.png 500w, https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/07\/Purview-Governance-800x604.png 800w\" sizes=\"(max-width: 953px) 100vw, 953px\" \/><\/noscript><img decoding=\"async\" width=\"953\" height=\"720\" src=\"https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/07\/Purview-Governance.png\" class=\"attachment-large size-large vp-lazyload\" alt=\"Enhancing Data Governance with Purview\" srcset=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iOTUzIiBoZWlnaHQ9IjcyMCIgdmlld0JveD0iMCAwIDk1MyA3MjAiIGZpbGw9Im5vbmUiIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyI+PC9zdmc+\" data-src=\"https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/07\/Purview-Governance.png\" data-srcset=\"https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/07\/Purview-Governance.png 953w, https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/07\/Purview-Governance-300x227.png 300w, https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/07\/Purview-Governance-768x580.png 768w, https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/07\/Purview-Governance-500x378.png 500w, https:\/\/mdw-group.com\/wp-content\/uploads\/2026\/07\/Purview-Governance-800x604.png 800w\" data-sizes=\"auto\" loading=\"eager\">\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<h6 class=\"uagb-post__title uagb-post__text\">\n\t\t\t\t<a href=\"https:\/\/mdw-group.com\/es\/enhancing-data-governance-through-purview\/\" target=\"_self\" rel=\"bookmark noopener noreferrer\">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<\/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.4 - 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}]}}