{"id":85096,"date":"2022-06-24T01:02:58","date_gmt":"2022-06-23T23:02:58","guid":{"rendered":"https:\/\/rmarketingdigital.com\/powerbi\/crear-jerarquia-en-power-bi\/"},"modified":"2020-09-17T20:49:02","modified_gmt":"2020-09-17T23:49:02","slug":"crear-jerarquia-en-power-bi","status":"publish","type":"post","link":"https:\/\/rmarketingdigital.com\/en\/powerbi\/crear-jerarquia-en-power-bi\/","title":{"rendered":"Create hierarchy in Power BI"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_86 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewbox=\"0 0 24 24\" version=\"1.2\" baseprofile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/rmarketingdigital.com\/en\/powerbi\/crear-jerarquia-en-power-bi\/#Como-crear-una-jerarquia-en-Power-BI\" >How to create a hierarchy in Power BI<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/rmarketingdigital.com\/en\/powerbi\/crear-jerarquia-en-power-bi\/#El-primer-enfoque-para-crear-jerarquia-en-Power-BI\" >The first approach to creating hierarchy in Power BI<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/rmarketingdigital.com\/en\/powerbi\/crear-jerarquia-en-power-bi\/#El-primer-enfoque-para-agregar-campos-a-una-jerarquia-de-Power-BI\" >The first approach to adding fields to a Power BI hierarchy<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/rmarketingdigital.com\/en\/powerbi\/crear-jerarquia-en-power-bi\/#El-segundo-enfoque-para-agregar-campos-a-una-jerarquia-de-Power-BI\" >The second approach to adding fields to a Power BI hierarchy<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/rmarketingdigital.com\/en\/powerbi\/crear-jerarquia-en-power-bi\/#Cambiar-niveles-de-jerarquia-en-Power-BI\" >Change hierarchy levels in Power BI<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/rmarketingdigital.com\/en\/powerbi\/crear-jerarquia-en-power-bi\/#Cambiar-el-nombre-de-la-jerarquia-en-Power-BI\" >Rename the hierarchy in Power BI<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/rmarketingdigital.com\/en\/powerbi\/crear-jerarquia-en-power-bi\/#Eliminar-jerarquia-en-Power-BI\" >Delete hierarchy in Power BI<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/rmarketingdigital.com\/en\/powerbi\/crear-jerarquia-en-power-bi\/#El-segundo-enfoque-para-crear-una-jerarquia-en-Power-BI\" >The second approach to creating a hierarchy in Power BI<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/rmarketingdigital.com\/en\/powerbi\/crear-jerarquia-en-power-bi\/#Eliminar-campos-de-la-jerarquia\" >Remove fields from the hierarchy<\/a><\/li><\/ul><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<div>\n<p>Power BI hierarchies provide you with the drilldown action of the BI report. Let me show you how to create a hierarchy in Power BI reports with an example.<\/p>\n<p><span id=\"ezoic-pub-ad-placeholder-104\"\/><span style=\"display:block !important;float:none !important;margin-bottom:15px !important;margin-left:0px !important;margin-right:0px !important;margin-top:15px !important;min-height:90px;min-width:728px;text-align:center !important;\" class=\"ezoic-ad medrectangle-3 adtester-container adtester-container-104\" data-ez-name=\"tutorialgateway_org-medrectangle-3\"><span id=\"div-gpt-ad-tutorialgateway_org-medrectangle-3-0\" ezaw=\"728\" ezah=\"90\" style=\"position:relative;z-index:0;display:inline-block;width:100%;max-width:1200px;margin-left:auto !important;margin-right:auto !important;min-height:90px;min-width:728px;\" class=\"ezoic-ad\"\/><\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Como-crear-una-jerarquia-en-Power-BI\"><\/span>How to create a hierarchy in Power BI<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>To demonstrate creating hierarchies in Power BI, we&#039;ll use the table we created in the article Combine Multiple Tables.<\/p>\n<figure class=\"wp-block-image\"><img alt='create-hierarchy-in-power-bi-1-5356465' width='1064' height='650' class=\"wp-image-31044\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-1-5356465.png 1064w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-1-5356465-300x183.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-1-5356465-1024x626.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-1-5356465-768x469.png 768w' data-lazy-sizes='(max-width: 1064px) 100vw, 1064px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-1-5356465.png'\/><noscript><img alt='create-hierarchy-in-power-bi-1-5356465' width='1064' height='650' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-1-5356465.png' class=\"wp-image-31044\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-1-5356465.png 1064w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-1-5356465-300x183.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-1-5356465-1024x626.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-1-5356465-768x469.png 768w' sizes='(max-width: 1064px) 100vw, 1064px'\/><\/noscript><\/figure>\n<p>There are a couple of ways to create a hierarchy.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"El-primer-enfoque-para-crear-jerarquia-en-Power-BI\"><\/span>The first approach to creating hierarchy in Power BI<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>To create a new hierarchy in Power BI, drag and drop one field onto the other. Automatically creates a hierarchy for you. To demonstrate the same in Power BI, we dragged the product subcategory into the product category field.<\/p>\n<figure class=\"wp-block-image\"><img alt='create-hierarchy-in-power-bi-2-4602603' width='1065' height='651' class=\"wp-image-31045\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-2-4602603.png 1065w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-2-4602603-300x183.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-2-4602603-1024x626.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-2-4602603-768x469.png 768w' data-lazy-sizes='(max-width: 1065px) 100vw, 1065px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-2-4602603.png'\/><noscript><img alt='create-hierarchy-in-power-bi-2-4602603' width='1065' height='651' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-2-4602603.png' class=\"wp-image-31045\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-2-4602603.png 1065w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-2-4602603-300x183.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-2-4602603-1024x626.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-2-4602603-768x469.png 768w' sizes='(max-width: 1065px) 100vw, 1065px'\/><\/noscript><\/figure>\n<p>Now you can see the newly created hierarchy.<\/p>\n<p><span id=\"ezoic-pub-ad-placeholder-105\"\/><span style=\"display:block !important;float:none !important;margin-bottom:15px !important;margin-left:0px !important;margin-right:0px !important;margin-top:15px !important;min-height:400px;min-width:580px;text-align:center !important;\" class=\"ezoic-ad box-4 adtester-container adtester-container-105\" data-ez-name=\"tutorialgateway_org-box-4\"><span id=\"div-gpt-ad-tutorialgateway_org-box-4-0\" ezaw=\"580\" ezah=\"400\" style=\"position:relative;z-index:0;display:inline-block;width:100%;max-width:1200px;margin-left:auto !important;margin-right:auto !important;min-height:400px;min-width:580px;\" class=\"ezoic-ad ezoic-adl\"\/><\/span><\/p>\n<figure class=\"wp-block-image\"><img alt='create-hierarchy-in-power-bi-3-8936823' width='1033' height='648' class=\"wp-image-31046\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-3-8936823.png 1033w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-3-8936823-300x188.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-3-8936823-1024x642.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-3-8936823-768x482.png 768w' data-lazy-sizes='(max-width: 1033px) 100vw, 1033px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-3-8936823.png'\/><noscript><img alt='create-hierarchy-in-power-bi-3-8936823' width='1033' height='648' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-3-8936823.png' class=\"wp-image-31046\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-3-8936823.png 1033w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-3-8936823-300x188.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-3-8936823-1024x642.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-3-8936823-768x482.png 768w' sizes='(max-width: 1033px) 100vw, 1033px'\/><\/noscript><\/figure>\n<h4><span class=\"ez-toc-section\" id=\"El-primer-enfoque-para-agregar-campos-a-una-jerarquia-de-Power-BI\"><\/span>The first approach to adding fields to a Power BI hierarchy<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>Drag and drop the required field into the newly created hierarchy. Let me drag the color field.<\/p>\n<figure class=\"wp-block-image\"><img alt='create-hierarchy-in-power-bi-4-5314846' width='1033' height='646' class=\"wp-image-31047\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-4-5314846.png 1033w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-4-5314846-300x188.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-4-5314846-1024x640.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-4-5314846-768x480.png 768w' data-lazy-sizes='(max-width: 1033px) 100vw, 1033px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-4-5314846.png'\/><noscript><img alt='create-hierarchy-in-power-bi-4-5314846' width='1033' height='646' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-4-5314846.png' class=\"wp-image-31047\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-4-5314846.png 1033w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-4-5314846-300x188.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-4-5314846-1024x640.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-4-5314846-768x480.png 768w' sizes='(max-width: 1033px) 100vw, 1033px'\/><\/noscript><\/figure>\n<p>You can now see the Color field within the hierarchy.<\/p>\n<figure class=\"wp-block-image\"><img alt='create-hierarchy-in-power-bi-5-8976914' width='1032' height='582' class=\"wp-image-31048\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-5-8976914.png 1032w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-5-8976914-300x169.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-5-8976914-1024x577.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-5-8976914-768x433.png 768w' data-lazy-sizes='(max-width: 1032px) 100vw, 1032px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-5-8976914.png'\/><noscript><img alt='create-hierarchy-in-power-bi-5-8976914' width='1032' height='582' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-5-8976914.png' class=\"wp-image-31048\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-5-8976914.png 1032w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-5-8976914-300x169.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-5-8976914-1024x577.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-5-8976914-768x433.png 768w' sizes='(max-width: 1032px) 100vw, 1032px'\/><\/noscript><\/figure>\n<h4><span class=\"ez-toc-section\" id=\"El-segundo-enfoque-para-agregar-campos-a-una-jerarquia-de-Power-BI\"><\/span>The second approach to adding fields to a Power BI hierarchy<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>Select the field you want to add (let me select the product) and right-click on it to open the context menu. Select Add to hierarchy and then select the hierarchy name (Product Category Hierarchy)<\/p>\n<figure class=\"wp-block-image\"><img alt='create-hierarchy-in-power-bi-6-6847494' width='1032' height='580' class=\"wp-image-31049\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-6-6847494.png 1032w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-6-6847494-300x169.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-6-6847494-1024x576.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-6-6847494-768x432.png 768w' data-lazy-sizes='(max-width: 1032px) 100vw, 1032px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-6-6847494.png'\/><noscript><img alt='create-hierarchy-in-power-bi-6-6847494' width='1032' height='580' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-6-6847494.png' class=\"wp-image-31049\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-6-6847494.png 1032w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-6-6847494-300x169.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-6-6847494-1024x576.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-6-6847494-768x432.png 768w' sizes='(max-width: 1032px) 100vw, 1032px'\/><\/noscript><\/figure>\n<p>Now you can see the Product under the hierarchy.<\/p>\n<figure class=\"wp-block-image\"><img alt='create-hierarchy-in-power-bi-7-3525715' width='246' height='433' class=\"wp-image-31050\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-7-3525715.png 246w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-7-3525715-170x300.png 170w' data-lazy-sizes='(max-width: 246px) 100vw, 246px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-7-3525715.png'\/><noscript><img alt='create-hierarchy-in-power-bi-7-3525715' width='246' height='433' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-7-3525715.png' class=\"wp-image-31050\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-7-3525715.png 246w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-7-3525715-170x300.png 170w' sizes='(max-width: 246px) 100vw, 246px'\/><\/noscript><\/figure>\n<h4><span class=\"ez-toc-section\" id=\"Cambiar-niveles-de-jerarquia-en-Power-BI\"><\/span>Change hierarchy levels in Power BI<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>Be careful when setting the hierarchy levels. For example, if you have the State column above Country, then Level 1 is State and Level 2 is Country.<\/p>\n<p>Select the field in which you want to change the position or level. Then right-click on it and select the Move Up (or Move Down) option from the context menu. Alternatively, drag and drop the field to the required position.<\/p>\n<figure class=\"wp-block-image\"><img alt='create-hierarchy-in-power-bi-8-8688636' width='1033' height='579' class=\"wp-image-31051\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-8-8688636.png 1033w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-8-8688636-300x168.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-8-8688636-1024x574.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-8-8688636-768x430.png 768w' data-lazy-sizes='(max-width: 1033px) 100vw, 1033px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-8-8688636.png'\/><noscript><img alt='create-hierarchy-in-power-bi-8-8688636' width='1033' height='579' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-8-8688636.png' class=\"wp-image-31051\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-8-8688636.png 1033w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-8-8688636-300x168.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-8-8688636-1024x574.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-8-8688636-768x430.png 768w' sizes='(max-width: 1033px) 100vw, 1033px'\/><\/noscript><\/figure>\n<p>Now you can see the product in the third position.<\/p>\n<figure class=\"wp-block-image\"><img alt='create-hierarchy-in-power-bi-9-2602457' width='1033' height='578' class=\"wp-image-31052\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-9-2602457.png 1033w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-9-2602457-300x168.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-9-2602457-1024x573.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-9-2602457-768x430.png 768w' data-lazy-sizes='(max-width: 1033px) 100vw, 1033px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-9-2602457.png'\/><noscript><img alt='create-hierarchy-in-power-bi-9-2602457' width='1033' height='578' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-9-2602457.png' class=\"wp-image-31052\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-9-2602457.png 1033w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-9-2602457-300x168.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-9-2602457-1024x573.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-9-2602457-768x430.png 768w' sizes='(max-width: 1033px) 100vw, 1033px'\/><\/noscript><\/figure>\n<h4><span class=\"ez-toc-section\" id=\"Cambiar-el-nombre-de-la-jerarquia-en-Power-BI\"><\/span>Rename the hierarchy in Power BI<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>Select the hierarchy you created and right-click on it to open the context menu. Select the Rename option from the context menu. Alternatively you can double click on the hierarchy name<\/p>\n<figure class=\"wp-block-image\"><img alt='create-hierarchy-in-power-bi-10-2685453' width='1033' height='581' class=\"wp-image-31053\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-10-2685453.png 1033w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-10-2685453-300x169.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-10-2685453-1024x576.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-10-2685453-768x432.png 768w' data-lazy-sizes='(max-width: 1033px) 100vw, 1033px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-10-2685453.png'\/><noscript><img alt='create-hierarchy-in-power-bi-10-2685453' width='1033' height='581' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-10-2685453.png' class=\"wp-image-31053\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-10-2685453.png 1033w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-10-2685453-300x169.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-10-2685453-1024x576.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-10-2685453-768x432.png 768w' sizes='(max-width: 1033px) 100vw, 1033px'\/><\/noscript><\/figure>\n<p>Let me rename it as product hierarchy<\/p>\n<figure class=\"wp-block-image\"><img alt='create-hierarchy-in-power-bi-11-6424890' width='282' height='436' class=\"wp-image-31054\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-11-6424890.png 282w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-11-6424890-194x300.png 194w' data-lazy-sizes='(max-width: 282px) 100vw, 282px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-11-6424890.png'\/><noscript><img alt='create-hierarchy-in-power-bi-11-6424890' width='282' height='436' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-11-6424890.png' class=\"wp-image-31054\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-11-6424890.png 282w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-11-6424890-194x300.png 194w' sizes='(max-width: 282px) 100vw, 282px'\/><\/noscript><\/figure>\n<p>Now you can see the new name<span id=\"ezoic-pub-ad-placeholder-106\" class=\"ezoic-adpicker-ad\"\/><span style=\"display:block !important;float:none;margin-bottom:15px !important;margin-left:0px !important;margin-right:0px !important;margin-top:15px !important;min-height:250px;min-width:300px;text-align:center !important;\" class=\"ezoic-ad banner-1 adtester-container adtester-container-106\" data-ez-name=\"tutorialgateway_org-banner-1\"><span id=\"div-gpt-ad-tutorialgateway_org-banner-1-0\" ezaw=\"300\" ezah=\"250\" style=\"position:relative;z-index:0;display:inline-block;min-height:250px;min-width:300px;\" class=\"ezoic-ad ezoic-adl\"\/><\/span><\/p>\n<figure class=\"wp-block-image\"><img alt='create-hierarchy-in-power-bi-12-6491520' width='901' height='583' class=\"wp-image-31055\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-12-6491520.png 901w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-12-6491520-300x194.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-12-6491520-768x497.png 768w' data-lazy-sizes='(max-width: 901px) 100vw, 901px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-12-6491520.png'\/><noscript><img alt='create-hierarchy-in-power-bi-12-6491520' width='901' height='583' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-12-6491520.png' class=\"wp-image-31055\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-12-6491520.png 901w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-12-6491520-300x194.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-12-6491520-768x497.png 768w' sizes='(max-width: 901px) 100vw, 901px'\/><\/noscript><\/figure>\n<h4><span class=\"ez-toc-section\" id=\"Eliminar-jerarquia-en-Power-BI\"><\/span>Delete hierarchy in Power BI<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>Select the hierarchy you delete and right-click on it to open the context menu. Select the Delete option from the context menu.<\/p>\n<figure class=\"wp-block-image\"><img alt='create-hierarchy-in-power-bi-13-1997518' width='901' height='584' class=\"wp-image-31056\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-13-1997518.png 901w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-13-1997518-300x194.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-13-1997518-768x498.png 768w' data-lazy-sizes='(max-width: 901px) 100vw, 901px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-13-1997518.png'\/><noscript><img alt='create-hierarchy-in-power-bi-13-1997518' width='901' height='584' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-13-1997518.png' class=\"wp-image-31056\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-13-1997518.png 901w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-13-1997518-300x194.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-13-1997518-768x498.png 768w' sizes='(max-width: 901px) 100vw, 901px'\/><\/noscript><\/figure>\n<p>Click the Delete button to confirm the delete operation.<\/p>\n<figure class=\"wp-block-image\"><img alt='create-hierarchy-in-power-bi-14-4397202' width='460' height='162' class=\"wp-image-31057\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-14-4397202.png 460w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-14-4397202-300x106.png 300w' data-lazy-sizes='(max-width: 460px) 100vw, 460px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-14-4397202.png'\/><noscript><img alt='create-hierarchy-in-power-bi-14-4397202' width='460' height='162' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-14-4397202.png' class=\"wp-image-31057\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-14-4397202.png 460w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-14-4397202-300x106.png 300w' sizes='(max-width: 460px) 100vw, 460px'\/><\/noscript><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"El-segundo-enfoque-para-crear-una-jerarquia-en-Power-BI\"><\/span>The second approach to creating a hierarchy in Power BI<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Select the file you want to use in the hierarchy and right-click to open the context menu. Select the New hierarchy option from the context menu.<\/p>\n<figure class=\"wp-block-image\"><img alt='create-hierarchy-in-power-bi-15-4518820' width='901' height='582' class=\"wp-image-31058\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-15-4518820.png 901w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-15-4518820-300x194.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-15-4518820-768x496.png 768w' data-lazy-sizes='(max-width: 901px) 100vw, 901px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-15-4518820.png'\/><noscript><img alt='create-hierarchy-in-power-bi-15-4518820' width='901' height='582' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-15-4518820.png' class=\"wp-image-31058\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-15-4518820.png 901w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-15-4518820-300x194.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-15-4518820-768x496.png 768w' sizes='(max-width: 901px) 100vw, 901px'\/><\/noscript><\/figure>\n<p>Create a new hierarchy for yourself.<\/p>\n<figure class=\"wp-block-image\"><img alt='create-hierarchy-in-power-bi-16-9696612' width='901' height='581' class=\"wp-image-31059\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-16-9696612.png 901w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-16-9696612-300x193.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-16-9696612-768x495.png 768w' data-lazy-sizes='(max-width: 901px) 100vw, 901px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-16-9696612.png'\/><noscript><img alt='create-hierarchy-in-power-bi-16-9696612' width='901' height='581' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-16-9696612.png' class=\"wp-image-31059\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-16-9696612.png 901w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-16-9696612-300x193.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-16-9696612-768x495.png 768w' sizes='(max-width: 901px) 100vw, 901px'\/><\/noscript><\/figure>\n<p>Let me add a few more fields<\/p>\n<figure class=\"wp-block-image\"><img alt='create-hierarchy-in-power-bi-17-4384444' width='901' height='582' class=\"wp-image-31060\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-17-4384444.png 901w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-17-4384444-300x194.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-17-4384444-768x496.png 768w' data-lazy-sizes='(max-width: 901px) 100vw, 901px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-17-4384444.png'\/><noscript><img alt='create-hierarchy-in-power-bi-17-4384444' width='901' height='582' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-17-4384444.png' class=\"wp-image-31060\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-17-4384444.png 901w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-17-4384444-300x194.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-17-4384444-768x496.png 768w' sizes='(max-width: 901px) 100vw, 901px'\/><\/noscript><\/figure>\n<h4><span class=\"ez-toc-section\" id=\"Eliminar-campos-de-la-jerarquia\"><\/span>Remove fields from the hierarchy<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>Select the field that you want to remove or remove from the hierarchy. Then right click on it and the Delete option from a context menu.<\/p>\n<figure class=\"wp-block-image\"><img alt='create-hierarchy-in-power-bi-18-6634755' width='899' height='534' class=\"wp-image-31061\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-18-6634755.png 899w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-18-6634755-300x178.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-18-6634755-768x456.png 768w' data-lazy-sizes='(max-width: 899px) 100vw, 899px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-18-6634755.png'\/><noscript><img alt='create-hierarchy-in-power-bi-18-6634755' width='899' height='534' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-18-6634755.png' class=\"wp-image-31061\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-18-6634755.png 899w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-18-6634755-300x178.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-18-6634755-768x456.png 768w' sizes='(max-width: 899px) 100vw, 899px'\/><\/noscript><\/figure>\n<p>Click the Remove button to remove the Color field from the hierarchy.<\/p>\n<figure class=\"wp-block-image\"><img alt='create-hierarchy-in-power-bi-19-2285032' width='460' height='162' class=\"wp-image-31062\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-19-2285032.png 460w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-19-2285032-300x106.png 300w' data-lazy-sizes='(max-width: 460px) 100vw, 460px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-19-2285032.png'\/><noscript><img alt='create-hierarchy-in-power-bi-19-2285032' width='460' height='162' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-19-2285032.png' class=\"wp-image-31062\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-19-2285032.png 460w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-19-2285032-300x106.png 300w' sizes='(max-width: 460px) 100vw, 460px'\/><\/noscript><\/figure>\n<p>You can see the same in the following screenshot.<\/p>\n<figure class=\"wp-block-image\"><img alt='create-hierarchy-in-power-bi-20-5989470' width='344' height='439' class=\"wp-image-31063\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-20-5989470.png 344w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-20-5989470-235x300.png 235w' data-lazy-sizes='(max-width: 344px) 100vw, 344px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-20-5989470.png'\/><noscript><img alt='create-hierarchy-in-power-bi-20-5989470' width='344' height='439' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-20-5989470.png' class=\"wp-image-31063\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-20-5989470.png 344w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-20-5989470-235x300.png 235w' sizes='(max-width: 344px) 100vw, 344px'\/><\/noscript><\/figure>\n<p>Again, we add the Color field and rename the hierarchy as Product Information.<\/p>\n<figure class=\"wp-block-image\"><img alt='create-hierarchy-in-power-bi-21-8331526' width='901' height='582' class=\"wp-image-31064\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-21-8331526.png 901w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-21-8331526-300x194.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-21-8331526-768x496.png 768w' data-lazy-sizes='(max-width: 901px) 100vw, 901px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-21-8331526.png'\/><noscript><img alt='create-hierarchy-in-power-bi-21-8331526' width='901' height='582' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-21-8331526.png' class=\"wp-image-31064\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-21-8331526.png 901w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-21-8331526-300x194.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-21-8331526-768x496.png 768w' sizes='(max-width: 901px) 100vw, 901px'\/><\/noscript><\/figure>\n<\/div>","protected":false},"excerpt":{"rendered":"<p>Power BI hierarchies provide you with the BI report drilldown action. Let me show you how to create a hierarchy in Power BI reports with an example. As\u2026<\/p>","protected":false},"author":1,"featured_media":85097,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1359,1360],"tags":[],"class_list":["post-85096","post","type-post","status-publish","format-standard","has-post-thumbnail","category-powerbi","category-tutoriales-power-bi"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.0 (Yoast SEO v28.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Crear jerarqu\u00eda en Power BI - R Marketing Digital<\/title>\n<meta name=\"description\" content=\"Las jerarqu\u00edas de Power BI le proporcionan la acci\u00f3n de desglose del informe de BI. Perm\u00edtame mostrarle c\u00f3mo crear una jerarqu\u00eda en informes de Power BI\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/rmarketingdigital.com\/en\/powerbi\/crear-jerarquia-en-power-bi\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Crear jerarqu\u00eda en Power BI\" \/>\n<meta property=\"og:description\" content=\"Las jerarqu\u00edas de Power BI le proporcionan la acci\u00f3n de desglose del informe de BI. Perm\u00edtame mostrarle c\u00f3mo crear una jerarqu\u00eda en informes de Power BI\" \/>\n<meta property=\"og:url\" content=\"https:\/\/rmarketingdigital.com\/en\/powerbi\/crear-jerarquia-en-power-bi\/\" \/>\n<meta property=\"og:site_name\" content=\"R Marketing Digital\" \/>\n<meta property=\"article:published_time\" content=\"2022-06-23T23:02:58+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-15-1153626.png\" \/>\n\t<meta property=\"og:image:width\" content=\"901\" \/>\n\t<meta property=\"og:image:height\" content=\"582\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"R Marketing Digital\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/crear-jerarquia-en-power-bi\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/crear-jerarquia-en-power-bi\\\/\"},\"author\":{\"name\":\"R Marketing Digital\",\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/#\\\/schema\\\/person\\\/7c0d9782b2977b840b3740f00c69a73e\"},\"headline\":\"Crear jerarqu\u00eda en Power BI\",\"datePublished\":\"2022-06-23T23:02:58+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/crear-jerarquia-en-power-bi\\\/\"},\"wordCount\":608,\"image\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/crear-jerarquia-en-power-bi\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/rmarketingdigital.com\\\/wp-content\\\/uploads\\\/2020\\\/09\\\/Create-Hierarchy-in-Power-BI-15-1153626.png\",\"articleSection\":[\"Power BI\",\"Tutoriales PowerBI\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/crear-jerarquia-en-power-bi\\\/\",\"url\":\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/crear-jerarquia-en-power-bi\\\/\",\"name\":\"Crear jerarqu\u00eda en Power BI - R Marketing Digital\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/crear-jerarquia-en-power-bi\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/crear-jerarquia-en-power-bi\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/rmarketingdigital.com\\\/wp-content\\\/uploads\\\/2020\\\/09\\\/Create-Hierarchy-in-Power-BI-15-1153626.png\",\"datePublished\":\"2022-06-23T23:02:58+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/#\\\/schema\\\/person\\\/7c0d9782b2977b840b3740f00c69a73e\"},\"description\":\"Las jerarqu\u00edas de Power BI le proporcionan la acci\u00f3n de desglose del informe de BI. Perm\u00edtame mostrarle c\u00f3mo crear una jerarqu\u00eda en informes de Power BI\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/crear-jerarquia-en-power-bi\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/crear-jerarquia-en-power-bi\\\/#primaryimage\",\"url\":\"https:\\\/\\\/rmarketingdigital.com\\\/wp-content\\\/uploads\\\/2020\\\/09\\\/Create-Hierarchy-in-Power-BI-15-1153626.png\",\"contentUrl\":\"https:\\\/\\\/rmarketingdigital.com\\\/wp-content\\\/uploads\\\/2020\\\/09\\\/Create-Hierarchy-in-Power-BI-15-1153626.png\",\"width\":901,\"height\":582,\"caption\":\"create-hierarchy-in-power-bi-15-1153626-3105565-png\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/#website\",\"url\":\"https:\\\/\\\/rmarketingdigital.com\\\/\",\"name\":\"R Marketing Digital\",\"description\":\"Agencia SEO | Publicidad redes sociales | Community Management\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/rmarketingdigital.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/#\\\/schema\\\/person\\\/7c0d9782b2977b840b3740f00c69a73e\",\"name\":\"R Marketing Digital\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/c5599c203e0120b8ccbff4666af86f35f9b3dcad468a8bc6295313a3964a80be?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/c5599c203e0120b8ccbff4666af86f35f9b3dcad468a8bc6295313a3964a80be?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/c5599c203e0120b8ccbff4666af86f35f9b3dcad468a8bc6295313a3964a80be?s=96&d=mm&r=g\",\"caption\":\"R Marketing Digital\"}}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Create hierarchy in Power BI - R Marketing Digital","description":"Power BI hierarchies provide you with the drilldown action of the BI report. Let me show you how to create a hierarchy in 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:\/\/rmarketingdigital.com\/en\/powerbi\/crear-jerarquia-en-power-bi\/","og_locale":"en_US","og_type":"article","og_title":"Crear jerarqu\u00eda en Power BI","og_description":"Las jerarqu\u00edas de Power BI le proporcionan la acci\u00f3n de desglose del informe de BI. Perm\u00edtame mostrarle c\u00f3mo crear una jerarqu\u00eda en informes de Power BI","og_url":"https:\/\/rmarketingdigital.com\/en\/powerbi\/crear-jerarquia-en-power-bi\/","og_site_name":"R Marketing Digital","article_published_time":"2022-06-23T23:02:58+00:00","og_image":[{"width":901,"height":582,"url":"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-15-1153626.png","type":"image\/png"}],"author":"R Marketing Digital","twitter_card":"summary_large_image","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/rmarketingdigital.com\/powerbi\/crear-jerarquia-en-power-bi\/#article","isPartOf":{"@id":"https:\/\/rmarketingdigital.com\/powerbi\/crear-jerarquia-en-power-bi\/"},"author":{"name":"R Marketing Digital","@id":"https:\/\/rmarketingdigital.com\/#\/schema\/person\/7c0d9782b2977b840b3740f00c69a73e"},"headline":"Crear jerarqu\u00eda en Power BI","datePublished":"2022-06-23T23:02:58+00:00","mainEntityOfPage":{"@id":"https:\/\/rmarketingdigital.com\/powerbi\/crear-jerarquia-en-power-bi\/"},"wordCount":608,"image":{"@id":"https:\/\/rmarketingdigital.com\/powerbi\/crear-jerarquia-en-power-bi\/#primaryimage"},"thumbnailUrl":"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-15-1153626.png","articleSection":["Power BI","Tutoriales PowerBI"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/rmarketingdigital.com\/powerbi\/crear-jerarquia-en-power-bi\/","url":"https:\/\/rmarketingdigital.com\/powerbi\/crear-jerarquia-en-power-bi\/","name":"Create hierarchy in Power BI - R Marketing Digital","isPartOf":{"@id":"https:\/\/rmarketingdigital.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/rmarketingdigital.com\/powerbi\/crear-jerarquia-en-power-bi\/#primaryimage"},"image":{"@id":"https:\/\/rmarketingdigital.com\/powerbi\/crear-jerarquia-en-power-bi\/#primaryimage"},"thumbnailUrl":"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-15-1153626.png","datePublished":"2022-06-23T23:02:58+00:00","author":{"@id":"https:\/\/rmarketingdigital.com\/#\/schema\/person\/7c0d9782b2977b840b3740f00c69a73e"},"description":"Power BI hierarchies provide you with the drilldown action of the BI report. Let me show you how to create a hierarchy in Power BI reports","inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/rmarketingdigital.com\/powerbi\/crear-jerarquia-en-power-bi\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/rmarketingdigital.com\/powerbi\/crear-jerarquia-en-power-bi\/#primaryimage","url":"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-15-1153626.png","contentUrl":"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-Hierarchy-in-Power-BI-15-1153626.png","width":901,"height":582,"caption":"create-hierarchy-in-power-bi-15-1153626-3105565-png"},{"@type":"WebSite","@id":"https:\/\/rmarketingdigital.com\/#website","url":"https:\/\/rmarketingdigital.com\/","name":"R Digital Marketing","description":"SEO Agency | Advertising social networks | Community Management","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/rmarketingdigital.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/rmarketingdigital.com\/#\/schema\/person\/7c0d9782b2977b840b3740f00c69a73e","name":"R Digital Marketing","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/c5599c203e0120b8ccbff4666af86f35f9b3dcad468a8bc6295313a3964a80be?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/c5599c203e0120b8ccbff4666af86f35f9b3dcad468a8bc6295313a3964a80be?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c5599c203e0120b8ccbff4666af86f35f9b3dcad468a8bc6295313a3964a80be?s=96&d=mm&r=g","caption":"R Marketing Digital"}}]}},"_links":{"self":[{"href":"https:\/\/rmarketingdigital.com\/en\/wp-json\/wp\/v2\/posts\/85096","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/rmarketingdigital.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/rmarketingdigital.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/rmarketingdigital.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/rmarketingdigital.com\/en\/wp-json\/wp\/v2\/comments?post=85096"}],"version-history":[{"count":0,"href":"https:\/\/rmarketingdigital.com\/en\/wp-json\/wp\/v2\/posts\/85096\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/rmarketingdigital.com\/en\/wp-json\/wp\/v2\/media\/85097"}],"wp:attachment":[{"href":"https:\/\/rmarketingdigital.com\/en\/wp-json\/wp\/v2\/media?parent=85096"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rmarketingdigital.com\/en\/wp-json\/wp\/v2\/categories?post=85096"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rmarketingdigital.com\/en\/wp-json\/wp\/v2\/tags?post=85096"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}