{"id":6394,"date":"2022-06-03T07:24:03","date_gmt":"2022-06-03T06:24:03","guid":{"rendered":"https:\/\/bestdatasolutions.es\/?p=6394"},"modified":"2022-06-21T11:38:48","modified_gmt":"2022-06-21T10:38:48","slug":"powerbi-field-parameters","status":"publish","type":"post","link":"https:\/\/bestdatasolutions.es\/en\/blog\/powerbi-field-parameters\/","title":{"rendered":"PowerBI Field Parameters"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"6394\" class=\"elementor elementor-6394 elementor-6393\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-d32b5ac elementor-section-full_width elementor-section-height-default elementor-section-height-default\" data-id=\"d32b5ac\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-no\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-c1dc6d3\" data-id=\"c1dc6d3\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-911012a elementor-widget elementor-widget-theme-post-featured-image elementor-widget-image\" data-id=\"911012a\" data-element_type=\"widget\" data-widget_type=\"theme-post-featured-image.default\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img fetchpriority=\"high\" decoding=\"async\" width=\"1920\" height=\"500\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/powerbi-filed-parameters.jpg\" class=\"attachment-full size-full wp-image-6562\" alt=\"powerbi-filed-parameters\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/powerbi-filed-parameters.jpg 1920w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/powerbi-filed-parameters-300x78.jpg 300w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/powerbi-filed-parameters-1024x267.jpg 1024w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/powerbi-filed-parameters-768x200.jpg 768w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/powerbi-filed-parameters-1536x400.jpg 1536w\" sizes=\"(max-width: 1920px) 100vw, 1920px\" title=\"\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-5d1c2c13 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5d1c2c13\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-5aae2e0d\" data-id=\"5aae2e0d\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-1a3ffa42 elementor-author-box--layout-image-left elementor-author-box--align-left elementor-author-box--image-valign-middle elementor-author-box--avatar-yes elementor-author-box--name-yes elementor-author-box--biography-yes elementor-widget elementor-widget-author-box\" data-id=\"1a3ffa42\" data-element_type=\"widget\" data-widget_type=\"author-box.default\">\n\t\t\t\t\t\t\t<div class=\"elementor-author-box\">\n\t\t\t\t\t\t\t<a href=\"https:\/\/www.linkedin.com\/in\/miquelzelich\/\" target=\"_blank\" class=\"elementor-author-box__avatar\" rel=\"noopener\">\n\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/avatar_user_7_1640247298.jpg\" alt=\"Picture of Miquel Zelich\" loading=\"lazy\" title=\"\">\n\t\t\t\t<\/a>\n\t\t\t\n\t\t\t<div class=\"elementor-author-box__text\">\n\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/www.linkedin.com\/in\/miquelzelich\/\" target=\"_blank\" rel=\"noopener\">\n\t\t\t\t\t\t<h4 class=\"elementor-author-box__name\">\n\t\t\t\t\t\t\tMiquel Zelich\t\t\t\t\t\t<\/h4>\n\t\t\t\t\t<\/a>\n\t\t\t\t\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-author-box__bio\">\n\t\t\t\t\t\tBusiness Intelligence Consultant | Data Analyst\t\t\t\t\t<\/div>\n\t\t\t\t\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-41a959e0 elementor-widget elementor-widget-heading\" data-id=\"41a959e0\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-large\">Other Articles:<\/h3>\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-6c75b22c\" data-id=\"6c75b22c\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-5795bde9 elementor-widget elementor-widget-theme-post-title elementor-page-title elementor-widget-heading\" data-id=\"5795bde9\" data-element_type=\"widget\" data-widget_type=\"theme-post-title.default\">\n\t\t\t\t\t<h1 class=\"elementor-heading-title elementor-size-xl\">PowerBI Field Parameters<\/h1>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-561b31d1 elementor-widget elementor-widget-post-info\" data-id=\"561b31d1\" data-element_type=\"widget\" data-widget_type=\"post-info.default\">\n\t\t\t\t\t\t\t<ul class=\"elementor-inline-items elementor-icon-list-items elementor-post-info\">\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item elementor-repeater-item-869d2fb elementor-inline-item\" itemprop=\"datePublished\">\n\t\t\t\t\t\t<a href=\"https:\/\/bestdatasolutions.es\/en\/2022\/06\/03\/\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t\t<svg aria-hidden=\"true\" class=\"e-font-icon-svg e-fas-calendar\" viewBox=\"0 0 448 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M12 192h424c6.6 0 12 5.4 12 12v260c0 26.5-21.5 48-48 48H48c-26.5 0-48-21.5-48-48V204c0-6.6 5.4-12 12-12zm436-44v-36c0-26.5-21.5-48-48-48h-48V12c0-6.6-5.4-12-12-12h-40c-6.6 0-12 5.4-12 12v52H160V12c0-6.6-5.4-12-12-12h-40c-6.6 0-12 5.4-12 12v52H48C21.5 64 0 85.5 0 112v36c0 6.6 5.4 12 12 12h424c6.6 0 12-5.4 12-12z\"><\/path><\/svg>\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text elementor-post-info__item elementor-post-info__item--type-date\">\n\t\t\t\t\t\t\t\t\t\t<time>03\/06\/2022<\/time>\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t<\/li>\n\t\t\t\t<\/ul>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7476169 elementor-share-buttons--view-icon-text elementor-share-buttons--skin-gradient elementor-share-buttons--shape-square elementor-grid-0 elementor-share-buttons--color-official elementor-widget elementor-widget-share-buttons\" data-id=\"7476169\" data-element_type=\"widget\" data-widget_type=\"share-buttons.default\">\n\t\t\t\t\t\t\t<div class=\"elementor-grid\" role=\"list\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-grid-item\" role=\"listitem\">\n\t\t\t\t\t\t<div class=\"elementor-share-btn elementor-share-btn_linkedin\" role=\"button\" tabindex=\"0\" aria-label=\"Share on linkedin\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__icon\">\n\t\t\t\t\t\t\t\t<svg aria-hidden=\"true\" class=\"e-font-icon-svg e-fab-linkedin\" viewBox=\"0 0 448 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><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>\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"elementor-share-btn__text\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__title\">\n\t\t\t\t\t\t\t\t\t\tLinkedIn\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-grid-item\" role=\"listitem\">\n\t\t\t\t\t\t<div class=\"elementor-share-btn elementor-share-btn_facebook\" role=\"button\" tabindex=\"0\" aria-label=\"Share on facebook\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__icon\">\n\t\t\t\t\t\t\t\t<svg aria-hidden=\"true\" class=\"e-font-icon-svg e-fab-facebook\" viewBox=\"0 0 512 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M504 256C504 119 393 8 256 8S8 119 8 256c0 123.78 90.69 226.38 209.25 245V327.69h-63V256h63v-54.64c0-62.15 37-96.48 93.67-96.48 27.14 0 55.52 4.84 55.52 4.84v61h-31.28c-30.8 0-40.41 19.12-40.41 38.73V256h68.78l-11 71.69h-57.78V501C413.31 482.38 504 379.78 504 256z\"><\/path><\/svg>\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"elementor-share-btn__text\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__title\">\n\t\t\t\t\t\t\t\t\t\tFacebook\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-grid-item\" role=\"listitem\">\n\t\t\t\t\t\t<div class=\"elementor-share-btn elementor-share-btn_twitter\" role=\"button\" tabindex=\"0\" aria-label=\"Share on twitter\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__icon\">\n\t\t\t\t\t\t\t\t<svg aria-hidden=\"true\" class=\"e-font-icon-svg e-fab-twitter\" viewBox=\"0 0 512 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M459.37 151.716c.325 4.548.325 9.097.325 13.645 0 138.72-105.583 298.558-298.558 298.558-59.452 0-114.68-17.219-161.137-47.106 8.447.974 16.568 1.299 25.34 1.299 49.055 0 94.213-16.568 130.274-44.832-46.132-.975-84.792-31.188-98.112-72.772 6.498.974 12.995 1.624 19.818 1.624 9.421 0 18.843-1.3 27.614-3.573-48.081-9.747-84.143-51.98-84.143-102.985v-1.299c13.969 7.797 30.214 12.67 47.431 13.319-28.264-18.843-46.781-51.005-46.781-87.391 0-19.492 5.197-37.36 14.294-52.954 51.655 63.675 129.3 105.258 216.365 109.807-1.624-7.797-2.599-15.918-2.599-24.04 0-57.828 46.782-104.934 104.934-104.934 30.213 0 57.502 12.67 76.67 33.137 23.715-4.548 46.456-13.32 66.599-25.34-7.798 24.366-24.366 44.833-46.132 57.827 21.117-2.273 41.584-8.122 60.426-16.243-14.292 20.791-32.161 39.308-52.628 54.253z\"><\/path><\/svg>\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"elementor-share-btn__text\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__title\">\n\t\t\t\t\t\t\t\t\t\tTwitter\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-grid-item\" role=\"listitem\">\n\t\t\t\t\t\t<div class=\"elementor-share-btn elementor-share-btn_whatsapp\" role=\"button\" tabindex=\"0\" aria-label=\"Share on whatsapp\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__icon\">\n\t\t\t\t\t\t\t\t<svg aria-hidden=\"true\" class=\"e-font-icon-svg e-fab-whatsapp\" viewBox=\"0 0 448 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M380.9 97.1C339 55.1 283.2 32 223.9 32c-122.4 0-222 99.6-222 222 0 39.1 10.2 77.3 29.6 111L0 480l117.7-30.9c32.4 17.7 68.9 27 106.1 27h.1c122.3 0 224.1-99.6 224.1-222 0-59.3-25.2-115-67.1-157zm-157 341.6c-33.2 0-65.7-8.9-94-25.7l-6.7-4-69.8 18.3L72 359.2l-4.4-7c-18.5-29.4-28.2-63.3-28.2-98.2 0-101.7 82.8-184.5 184.6-184.5 49.3 0 95.6 19.2 130.4 54.1 34.8 34.9 56.2 81.2 56.1 130.5 0 101.8-84.9 184.6-186.6 184.6zm101.2-138.2c-5.5-2.8-32.8-16.2-37.9-18-5.1-1.9-8.8-2.8-12.5 2.8-3.7 5.6-14.3 18-17.6 21.8-3.2 3.7-6.5 4.2-12 1.4-32.6-16.3-54-29.1-75.5-66-5.7-9.8 5.7-9.1 16.3-30.3 1.8-3.7.9-6.9-.5-9.7-1.4-2.8-12.5-30.1-17.1-41.2-4.5-10.8-9.1-9.3-12.5-9.5-3.2-.2-6.9-.2-10.6-.2-3.7 0-9.7 1.4-14.8 6.9-5.1 5.6-19.4 19-19.4 46.3 0 27.3 19.9 53.7 22.6 57.4 2.8 3.7 39.1 59.7 94.8 83.8 35.2 15.2 49 16.5 66.6 13.9 10.7-1.6 32.8-13.4 37.4-26.4 4.6-13 4.6-24.1 3.2-26.4-1.3-2.5-5-3.9-10.5-6.6z\"><\/path><\/svg>\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"elementor-share-btn__text\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__title\">\n\t\t\t\t\t\t\t\t\t\tWhatsApp\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ea9e43f elementor-widget elementor-widget-heading\" data-id=\"ea9e43f\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Introduction<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-56263e9 elementor-widget elementor-widget-text-editor\" data-id=\"56263e9\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>Today we want to talk to you about field parameters. Field parameters are a new feature in Power BI, still in the preview phase, that allows us to dynamically change the dimensions or metrics used in the visualizations.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f4d4fdb elementor-widget elementor-widget-text-editor\" data-id=\"f4d4fdb\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p><span style=\"font-family: var( --e-global-typography-text-font-family ), Sans-serif; font-size: 1rem; font-weight: var( --e-global-typography-text-font-weight );\">This feature is mainly intended for report readers accessing the Power Bi Service as they will be able to change the analysis object of the visualizations from a selector without having to enter edit mode.<\/span><\/p><p>In this example, the end-user has the ability to modify the fields by which he\/she wants to group the data and the metrics to be analyzed:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-5b5e4af elementor-widget elementor-widget-image\" data-id=\"5b5e4af\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"800\" height=\"456\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/parametros-dimensiones-powerbi-ejemplo.jpg\" class=\"attachment-large size-large wp-image-6357\" alt=\"parameters-dimensions-powerbi-example\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/parametros-dimensiones-powerbi-ejemplo.jpg 800w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/parametros-dimensiones-powerbi-ejemplo-300x171.jpg 300w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/parametros-dimensiones-powerbi-ejemplo-768x438.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" title=\"\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0911814 elementor-widget elementor-widget-text-editor\" data-id=\"0911814\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>Before this update, it was possible to achieve this behavior, but with more effort. At first, it only worked with metrics and the creation process was more tedious, having to create a table, either with DAX, Power Query, or with the Insert Data mode with the names of the metrics we wanted to change dynamically to create the selector. With this additional table we would create a metric using the SWITCH() function in order to link the selected value of this table with the actual metric.<\/p><p>This process is much easier with the help of the Field Parameters.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-499a375 elementor-widget elementor-widget-heading\" data-id=\"499a375\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Enable feature:<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-02405d1 elementor-widget elementor-widget-text-editor\" data-id=\"02405d1\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>First, we have to activate the feature<\/p>\n<p>1. Make sure you have the latest version of Power BI Desktop at the time of this article, &nbsp; <b>2022.<\/b><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a572d83 elementor-widget elementor-widget-image\" data-id=\"a572d83\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"800\" height=\"461\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/como-habilitar-parametros-de-campo-paso-1.jpg\" class=\"attachment-large size-large wp-image-6360\" alt=\"how-to enable-field-parameters-step-1\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/como-habilitar-parametros-de-campo-paso-1.jpg 800w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/como-habilitar-parametros-de-campo-paso-1-300x173.jpg 300w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/como-habilitar-parametros-de-campo-paso-1-768x443.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" title=\"\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9f24ed3 elementor-widget elementor-widget-text-editor\" data-id=\"9f24ed3\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>2. We enable the preview version in <b>File bold, &gt; Options and settings bold, &gt; Options bold, &gt; Preview version features:<\/b><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-46e4575 elementor-widget elementor-widget-image\" data-id=\"46e4575\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"772\" height=\"744\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/como-habilitar-parametros-de-campo-paso-2.jpg\" class=\"attachment-large size-large wp-image-6363\" alt=\"How-to-enable-field-parameters-step-2\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/como-habilitar-parametros-de-campo-paso-2.jpg 772w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/como-habilitar-parametros-de-campo-paso-2-300x289.jpg 300w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/como-habilitar-parametros-de-campo-paso-2-768x740.jpg 768w\" sizes=\"(max-width: 772px) 100vw, 772px\" title=\"\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a2272fb elementor-widget elementor-widget-text-editor\" data-id=\"a2272fb\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>3. We restart Power BI Desktop.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d1e7556 elementor-widget elementor-widget-heading\" data-id=\"d1e7556\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Create a field parameter<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f30afac elementor-widget elementor-widget-text-editor\" data-id=\"f30afac\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>Once we have the feature enabled we can create the parameters.<\/p><p>1. To create them, go to <b>Modeling<\/b> and select <b>New parameter bold, &gt; Fields:<\/b><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d947428 elementor-widget elementor-widget-image\" data-id=\"d947428\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"754\" height=\"340\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/como-crear-un-parametro-de-campo-paso1.jpg\" class=\"attachment-large size-large wp-image-6366\" alt=\"how-to-create-a-field-parameter-step1\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/como-crear-un-parametro-de-campo-paso1.jpg 754w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/como-crear-un-parametro-de-campo-paso1-300x135.jpg 300w\" sizes=\"(max-width: 754px) 100vw, 754px\" title=\"\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d75ae25 elementor-widget elementor-widget-text-editor\" data-id=\"d75ae25\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>2. In the window we select the fields we want to add in the field selector:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8747d52 elementor-widget elementor-widget-image\" data-id=\"8747d52\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"685\" height=\"667\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/como-crear-un-parametro-de-campo-paso-2.jpg\" class=\"attachment-large size-large wp-image-6369\" alt=\"how-to-create-a-field-parameter-step2\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/como-crear-un-parametro-de-campo-paso-2.jpg 685w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/como-crear-un-parametro-de-campo-paso-2-300x292.jpg 300w\" sizes=\"(max-width: 685px) 100vw, 685px\" title=\"\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3853103 elementor-widget elementor-widget-text-editor\" data-id=\"3853103\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>With these steps, Power BI will create a selector in our report with the selected fields and a table with DAX with 3 columns: name of the field, real name of the column, and order of the different fields. This table allows us to create the selector.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-31ac073 elementor-widget elementor-widget-image\" data-id=\"31ac073\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"777\" height=\"427\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/como-crear-un-parametro-de-campo-paso-3.jpg\" class=\"attachment-large size-large wp-image-6372\" alt=\"how-to-create-a-field-parameter-step3\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/como-crear-un-parametro-de-campo-paso-3.jpg 777w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/como-crear-un-parametro-de-campo-paso-3-300x165.jpg 300w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/como-crear-un-parametro-de-campo-paso-3-768x422.jpg 768w\" sizes=\"(max-width: 777px) 100vw, 777px\" title=\"\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-72ebda4 elementor-widget elementor-widget-text-editor\" data-id=\"72ebda4\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>*The first column is the name that will be displayed in the visualization and can be modified directly in the DAX code. You can also add a new parameter following the same structure.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-50cbf2f elementor-widget elementor-widget-heading\" data-id=\"50cbf2f\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Use of the field parameters<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-5950f27 elementor-widget elementor-widget-text-editor\" data-id=\"5950f27\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>With all created now, we only need to add the parameter field in our visual object. In this case, we have created a selector with dimension fields so we will add the field on the Y axis:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9763006 elementor-widget elementor-widget-image\" data-id=\"9763006\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"784\" height=\"411\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/selector-campo-de-dimensiones.jpg\" class=\"attachment-large size-large wp-image-6375\" alt=\"dimension-field-selector\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/selector-campo-de-dimensiones.jpg 784w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/selector-campo-de-dimensiones-300x157.jpg 300w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/selector-campo-de-dimensiones-768x403.jpg 768w\" sizes=\"(max-width: 784px) 100vw, 784px\" title=\"\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-081d04f elementor-widget elementor-widget-text-editor\" data-id=\"081d04f\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>The selector allows us to change the field we can group by<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f0da690 elementor-widget elementor-widget-image\" data-id=\"f0da690\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"781\" height=\"547\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/selector-para-cambiar-parametros-de-campo.jpg\" class=\"attachment-large size-large wp-image-6378\" alt=\"selector-for-change-field-parameters\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/selector-para-cambiar-parametros-de-campo.jpg 781w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/selector-para-cambiar-parametros-de-campo-300x210.jpg 300w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/selector-para-cambiar-parametros-de-campo-768x538.jpg 768w\" sizes=\"(max-width: 781px) 100vw, 781px\" title=\"\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-fcec2b9 elementor-widget elementor-widget-text-editor\" data-id=\"fcec2b9\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>In the same way, we can create a field parameter with created metrics and change the analyzable metrics.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b21ea08 elementor-widget elementor-widget-image\" data-id=\"b21ea08\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"787\" height=\"286\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/cambiar-metricas-en-un-parametro-de-campo.jpg\" class=\"attachment-large size-large wp-image-6381\" alt=\"change-metrics-in-a-field-parameter\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/cambiar-metricas-en-un-parametro-de-campo.jpg 787w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/cambiar-metricas-en-un-parametro-de-campo-300x109.jpg 300w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/cambiar-metricas-en-un-parametro-de-campo-768x279.jpg 768w\" sizes=\"(max-width: 787px) 100vw, 787px\" title=\"\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-dcd77a2 elementor-widget elementor-widget-text-editor\" data-id=\"dcd77a2\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>And in this way be able to interact with the two selectors:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b42560f elementor-widget elementor-widget-image\" data-id=\"b42560f\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"783\" height=\"403\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/selectores-en-los-parametros-de-campo.jpg\" class=\"attachment-large size-large wp-image-6384\" alt=\"Field-parameter-selectors\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/selectores-en-los-parametros-de-campo.jpg 783w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/selectores-en-los-parametros-de-campo-300x154.jpg 300w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/selectores-en-los-parametros-de-campo-768x395.jpg 768w\" sizes=\"(max-width: 783px) 100vw, 783px\" title=\"\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d91919b elementor-widget elementor-widget-text-editor\" data-id=\"d91919b\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>If more than one field of the selector is selected, all selected fields will be shown in the display.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-26a4048 elementor-widget elementor-widget-heading\" data-id=\"26a4048\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Concluding remarks<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d85c738 elementor-widget elementor-widget-text-editor\" data-id=\"d85c738\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>For this feature to work well and in any field, it is very important to have a well-defined model and a star model as it allows us to get the most out of Power BI and ensure the correct use of the model relationships.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-614b2ec9 elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"614b2ec9\" data-element_type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c77df54 elementor-align-center elementor-widget elementor-widget-button\" data-id=\"c77df54\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t\t\t\t\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm\" href=\"https:\/\/bestdatasolutions.es\/en\/blog\/\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t\t\t\t<span class=\"elementor-button-text\">&lt;&lt; BACK TO BLOG<\/span>\n\t\t\t\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Other Articles: Share on linkedin LinkedIn Share on facebook Facebook Share on twitter Twitter Share on whatsapp WhatsApp Introduction Today we want to talk to you about field parameters. Field parameters are a new feature in Power BI, still in the preview phase, that allows us to dynamically change the dimensions or metrics used in [&hellip;]<\/p>\n","protected":false},"author":7,"featured_media":6562,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[49],"tags":[75],"class_list":["post-6394","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-blog","tag-powerbi-en"],"_links":{"self":[{"href":"https:\/\/bestdatasolutions.es\/en\/wp-json\/wp\/v2\/posts\/6394","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bestdatasolutions.es\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bestdatasolutions.es\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bestdatasolutions.es\/en\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/bestdatasolutions.es\/en\/wp-json\/wp\/v2\/comments?post=6394"}],"version-history":[{"count":0,"href":"https:\/\/bestdatasolutions.es\/en\/wp-json\/wp\/v2\/posts\/6394\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/bestdatasolutions.es\/en\/wp-json\/wp\/v2\/media\/6562"}],"wp:attachment":[{"href":"https:\/\/bestdatasolutions.es\/en\/wp-json\/wp\/v2\/media?parent=6394"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bestdatasolutions.es\/en\/wp-json\/wp\/v2\/categories?post=6394"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bestdatasolutions.es\/en\/wp-json\/wp\/v2\/tags?post=6394"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}