{"id":84848,"date":"2022-07-11T23:32:02","date_gmt":"2022-07-11T21:32:02","guid":{"rendered":"https:\/\/rmarketingdigital.com\/powerbi\/anular-tabla-dinamica-en-power-bi\/"},"modified":"2020-09-17T17:36:39","modified_gmt":"2020-09-17T20:36:39","slug":"anular-tabla-dinamica-en-power-bi","status":"publish","type":"post","link":"https:\/\/rmarketingdigital.com\/en\/powerbi\/anular-tabla-dinamica-en-power-bi\/","title":{"rendered":"Override pivot table 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\/anular-tabla-dinamica-en-power-bi\/#Como-crear-una-tabla-sin-divisiones-en-Power-BI\" >How to create a table without divisions 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\/anular-tabla-dinamica-en-power-bi\/#El-primer-enfoque-para-desvincular-tablas-en-Power-BI\" >The first approach to unlinking tables in Power BI<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/rmarketingdigital.com\/en\/powerbi\/anular-tabla-dinamica-en-power-bi\/#El-segundo-enfoque-para-desvincular-tablas-en-Power-BI\" >The second approach to unlinking tables in Power BI<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/rmarketingdigital.com\/en\/powerbi\/anular-tabla-dinamica-en-power-bi\/#El-tercer-enfoque-para-desvincular-tablas-en-Power-BI\" >The third approach to unlinking tables in Power BI<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<div>\n<p>The Unpivot table option in Power BI converts selected columns to rows. Let&#039;s see how to create Unpivot table or how to convert pivot table to Unpivot table in Power BI 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 ezoic-adl\"\/><\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Como-crear-una-tabla-sin-divisiones-en-Power-BI\"><\/span>How to create a table without divisions in Power BI<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>To create or convert a pivot table to a table without divisions, click the <strong>Edit queries<\/strong> option under the <strong>Home<\/strong> tongue.<\/p>\n<figure class=\"wp-block-image\"><img alt='unpivot-table-in-power-bi-1-9530353' width='1057' height='628' class=\"wp-image-30961\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-1-9530353.png 1057w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-1-9530353-300x178.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-1-9530353-1024x608.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-1-9530353-768x456.png 768w' data-lazy-sizes='(max-width: 1057px) 100vw, 1057px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-1-9530353.png'\/><noscript><img alt='unpivot-table-in-power-bi-1-9530353' width='1057' height='628' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-1-9530353.png' class=\"wp-image-30961\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-1-9530353.png 1057w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-1-9530353-300x178.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-1-9530353-1024x608.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-1-9530353-768x456.png 768w' sizes='(max-width: 1057px) 100vw, 1057px'\/><\/noscript><\/figure>\n<p>By clicking on the <strong>Edit queries<\/strong> The option opens a new window called Power BI <strong>Power Query Editor<\/strong>.<span id=\"ezoic-pub-ad-placeholder-132\" class=\"ezoic-adpicker-ad\"\/><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:250px;min-width:300px;text-align:center !important;\" class=\"ezoic-ad box-3 adtester-container adtester-container-132\" data-ez-name=\"tutorialgateway_org-box-3\"><span id=\"div-gpt-ad-tutorialgateway_org-box-3-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<p>In this Unpivot Table example, we are going to univot columns 2005, 2006, 2006, and 2007.<\/p>\n<figure class=\"wp-block-image\"><img alt='unpivot-table-in-power-bi-2-4811171' width='1186' height='730' class=\"wp-image-30962\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-2-4811171.png 1186w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-2-4811171-300x185.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-2-4811171-1024x630.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-2-4811171-768x473.png 768w' data-lazy-sizes='(max-width: 1186px) 100vw, 1186px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-2-4811171.png'\/><noscript><img alt='unpivot-table-in-power-bi-2-4811171' width='1186' height='730' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-2-4811171.png' class=\"wp-image-30962\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-2-4811171.png 1186w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-2-4811171-300x185.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-2-4811171-1024x630.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-2-4811171-768x473.png 768w' sizes='(max-width: 1186px) 100vw, 1186px'\/><\/noscript><\/figure>\n<p>There are a couple of ways to unlink the table<\/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\"\/><\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"El-primer-enfoque-para-desvincular-tablas-en-Power-BI\"><\/span>The first approach to unlinking tables in Power BI<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Select the columns that you do not want to unlink or if you want to keep them unchanged, the context menu will open. Select the <b>Remove other columns<\/b> option. This triggers all columns except the selected ones.<\/p>\n<figure class=\"wp-block-image\"><img alt='unpivot-table-in-power-bi-3-6523457' width='1181' height='731' class=\"wp-image-30963\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-3-6523457.png 1181w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-3-6523457-300x186.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-3-6523457-1024x634.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-3-6523457-768x475.png 768w' data-lazy-sizes='(max-width: 1181px) 100vw, 1181px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-3-6523457.png'\/><noscript><img alt='unpivot-table-in-power-bi-3-6523457' width='1181' height='731' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-3-6523457.png' class=\"wp-image-30963\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-3-6523457.png 1181w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-3-6523457-300x186.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-3-6523457-1024x634.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-3-6523457-768x475.png 768w' sizes='(max-width: 1181px) 100vw, 1181px'\/><\/noscript><\/figure>\n<p>Now you can see the table without a pivot.<\/p>\n<figure class=\"wp-block-image\"><img alt='unpivot-table-in-power-bi-4-5106609' width='1182' height='699' class=\"wp-image-30964\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-4-5106609.png 1182w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-4-5106609-300x177.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-4-5106609-1024x606.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-4-5106609-768x454.png 768w' data-lazy-sizes='(max-width: 1182px) 100vw, 1182px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-4-5106609.png'\/><noscript><img alt='unpivot-table-in-power-bi-4-5106609' width='1182' height='699' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-4-5106609.png' class=\"wp-image-30964\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-4-5106609.png 1182w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-4-5106609-300x177.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-4-5106609-1024x606.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-4-5106609-768x454.png 768w' sizes='(max-width: 1182px) 100vw, 1182px'\/><\/noscript><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"El-segundo-enfoque-para-desvincular-tablas-en-Power-BI\"><\/span>The second approach to unlinking tables in Power BI<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Select the columns you want to unlink to open the context menu. Please select <b>Drop only selected columns <\/b>option. This unwraps all the selected columns.<\/p>\n<figure class=\"wp-block-image\"><img alt='unpivot-table-in-power-bi-5-2341455' width='1183' height='700' class=\"wp-image-30965\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-5-2341455.png 1183w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-5-2341455-300x178.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-5-2341455-1024x606.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-5-2341455-768x454.png 768w' data-lazy-sizes='(max-width: 1183px) 100vw, 1183px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-5-2341455.png'\/><noscript><img alt='unpivot-table-in-power-bi-5-2341455' width='1183' height='700' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-5-2341455.png' class=\"wp-image-30965\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-5-2341455.png 1183w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-5-2341455-300x178.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-5-2341455-1024x606.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-5-2341455-768x454.png 768w' sizes='(max-width: 1183px) 100vw, 1183px'\/><\/noscript><\/figure>\n<p>Now you can see the table without a pivot.<\/p>\n<figure class=\"wp-block-image\"><img alt='unpivot-table-in-power-bi-6-9335172' width='1036' height='700' class=\"wp-image-30966\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-6-9335172.png 1036w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-6-9335172-300x203.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-6-9335172-1024x692.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-6-9335172-768x519.png 768w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-6-9335172-400x269.png 400w' data-lazy-sizes='(max-width: 1036px) 100vw, 1036px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-6-9335172.png'\/><noscript><img alt='unpivot-table-in-power-bi-6-9335172' width='1036' height='700' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-6-9335172.png' class=\"wp-image-30966\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-6-9335172.png 1036w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-6-9335172-300x203.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-6-9335172-1024x692.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-6-9335172-768x519.png 768w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-6-9335172-400x269.png 400w' sizes='(max-width: 1036px) 100vw, 1036px'\/><\/noscript><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"El-tercer-enfoque-para-desvincular-tablas-en-Power-BI\"><\/span>The third approach to unlinking tables in Power BI<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>To convert the pivot table to the table without divisions, go to <strong>Transform<\/strong> Tongue. In this tab, you can find the <strong>Remove column pivot<\/strong> button as shown below.<\/p>\n<figure class=\"wp-block-image\"><img alt='unpivot-table-in-power-bi-7-6802205' width='1299' height='731' class=\"wp-image-30967\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-7-6802205.png 1299w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-7-6802205-300x169.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-7-6802205-1024x576.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-7-6802205-768x432.png 768w' data-lazy-sizes='(max-width: 1299px) 100vw, 1299px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-7-6802205.png'\/><noscript><img alt='unpivot-table-in-power-bi-7-6802205' width='1299' height='731' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-7-6802205.png' class=\"wp-image-30967\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-7-6802205.png 1299w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-7-6802205-300x169.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-7-6802205-1024x576.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-7-6802205-768x432.png 768w' sizes='(max-width: 1299px) 100vw, 1299px'\/><\/noscript><\/figure>\n<p>Use the drop-down list to unlink the table. For the purpose of demonstrating the Unpivot Table, we select the Product ID and Name columns, and then select the <strong>Remove other columns<\/strong> option.<\/p>\n<figure class=\"wp-block-image\"><img alt='unpivot-table-in-power-bi-8-9974124' width='1300' height='730' class=\"wp-image-30968\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-8-9974124.png 1300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-8-9974124-300x168.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-8-9974124-1024x575.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-8-9974124-768x431.png 768w' data-lazy-sizes='(max-width: 1300px) 100vw, 1300px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-8-9974124.png'\/><noscript><img alt='unpivot-table-in-power-bi-8-4068059' width='1300' height='730' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-8-4068059.png' class=\"wp-image-30968\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-8-4068059.png 1300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-8-4068059-300x168.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-8-4068059-1024x575.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-8-4068059-768x431.png 768w' sizes='(max-width: 1300px) 100vw, 1300px'\/><\/noscript><\/figure>\n<p>Now you can see the table without divisions.<\/p>\n<figure class=\"wp-block-image\"><img alt='unpivot-table-in-power-bi-9-1396796' width='1039' height='733' class=\"wp-image-30969\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-9-1396796.png 1039w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-9-1396796-300x212.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-9-1396796-1024x722.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-9-1396796-768x542.png 768w' data-lazy-sizes='(max-width: 1039px) 100vw, 1039px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-9-1396796.png'\/><noscript><img alt='unpivot-table-in-power-bi-9-2815649' width='1039' height='733' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-9-2815649.png' class=\"wp-image-30969\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-9-2815649.png 1039w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-9-2815649-300x212.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-9-2815649-1024x722.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-9-2815649-768x542.png 768w' sizes='(max-width: 1039px) 100vw, 1039px'\/><\/noscript><\/figure>\n<p>We change the name of the columns to more meaningful ones. Then press the <strong>Close and apply <\/strong>option under the <strong>Home<\/strong> tab to apply these changes.<\/p>\n<figure class=\"wp-block-image\"><img alt='unpivot-table-in-power-bi-10-5970819' width='1043' height='762' class=\"wp-image-30970\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-10-5970819.png 1043w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-10-5970819-300x219.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-10-5970819-1024x748.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-10-5970819-768x561.png 768w' data-lazy-sizes='(max-width: 1043px) 100vw, 1043px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-10-5970819.png'\/><noscript><img alt='unpivot-table-in-power-bi-10-2889960' width='1043' height='762' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-10-2889960.png' class=\"wp-image-30970\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-10-2889960.png 1043w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-10-2889960-300x219.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-10-2889960-1024x748.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-10-2889960-768x561.png 768w' sizes='(max-width: 1043px) 100vw, 1043px'\/><\/noscript><\/figure>\n<p>In the screenshot below, you can see the columns without divisions on the right side.<\/p>\n<figure class=\"wp-block-image\"><img alt='unpivot-table-in-power-bi-11-1879167' width='1019' height='590' class=\"wp-image-30971\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-11-1879167.png 1019w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-11-1879167-300x174.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-11-1879167-768x445.png 768w' data-lazy-sizes='(max-width: 1019px) 100vw, 1019px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-11-1879167.png'\/><noscript><img alt='unpivot-table-in-power-bi-11-6555115' width='1019' height='590' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-11-6555115.png' class=\"wp-image-30971\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-11-6555115.png 1019w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-11-6555115-300x174.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-11-6555115-768x445.png 768w' sizes='(max-width: 1019px) 100vw, 1019px'\/><\/noscript><\/figure>\n<\/div>","protected":false},"excerpt":{"rendered":"<p>The Power BI Unpivot table option converts selected columns to rows. Let&#039;s see how to create an Unpivot table or how to convert the pivot table to the Unpivot table\u2026<\/p>","protected":false},"author":1,"featured_media":84847,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1359,1360],"tags":[],"class_list":["post-84848","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>Anular tabla din\u00e1mica en Power BI - R Marketing Digital<\/title>\n<meta name=\"description\" content=\"La opci\u00f3n de tabla Unpivot de Power BI convierte las columnas seleccionadas en filas. Veamos c\u00f3mo crear una tabla Unpivot o c\u00f3mo convertir la tabla\" \/>\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\/anular-tabla-dinamica-en-power-bi\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Anular tabla din\u00e1mica en Power BI\" \/>\n<meta property=\"og:description\" content=\"La opci\u00f3n de tabla Unpivot de Power BI convierte las columnas seleccionadas en filas. Veamos c\u00f3mo crear una tabla Unpivot o c\u00f3mo convertir la tabla\" \/>\n<meta property=\"og:url\" content=\"https:\/\/rmarketingdigital.com\/en\/powerbi\/anular-tabla-dinamica-en-power-bi\/\" \/>\n<meta property=\"og:site_name\" content=\"R Marketing Digital\" \/>\n<meta property=\"article:published_time\" content=\"2022-07-11T21:32:02+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-3-8488367.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1181\" \/>\n\t<meta property=\"og:image:height\" content=\"731\" \/>\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\\\/anular-tabla-dinamica-en-power-bi\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/anular-tabla-dinamica-en-power-bi\\\/\"},\"author\":{\"name\":\"R Marketing Digital\",\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/#\\\/schema\\\/person\\\/7c0d9782b2977b840b3740f00c69a73e\"},\"headline\":\"Anular tabla din\u00e1mica en Power BI\",\"datePublished\":\"2022-07-11T21:32:02+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/anular-tabla-dinamica-en-power-bi\\\/\"},\"wordCount\":346,\"image\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/anular-tabla-dinamica-en-power-bi\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/rmarketingdigital.com\\\/wp-content\\\/uploads\\\/2020\\\/09\\\/Unpivot-Table-in-Power-BI-3-8488367.png\",\"articleSection\":[\"Power BI\",\"Tutoriales PowerBI\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/anular-tabla-dinamica-en-power-bi\\\/\",\"url\":\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/anular-tabla-dinamica-en-power-bi\\\/\",\"name\":\"Anular tabla din\u00e1mica en Power BI - R Marketing Digital\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/anular-tabla-dinamica-en-power-bi\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/anular-tabla-dinamica-en-power-bi\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/rmarketingdigital.com\\\/wp-content\\\/uploads\\\/2020\\\/09\\\/Unpivot-Table-in-Power-BI-3-8488367.png\",\"datePublished\":\"2022-07-11T21:32:02+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/#\\\/schema\\\/person\\\/7c0d9782b2977b840b3740f00c69a73e\"},\"description\":\"La opci\u00f3n de tabla Unpivot de Power BI convierte las columnas seleccionadas en filas. Veamos c\u00f3mo crear una tabla Unpivot o c\u00f3mo convertir la tabla\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/anular-tabla-dinamica-en-power-bi\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/anular-tabla-dinamica-en-power-bi\\\/#primaryimage\",\"url\":\"https:\\\/\\\/rmarketingdigital.com\\\/wp-content\\\/uploads\\\/2020\\\/09\\\/Unpivot-Table-in-Power-BI-3-8488367.png\",\"contentUrl\":\"https:\\\/\\\/rmarketingdigital.com\\\/wp-content\\\/uploads\\\/2020\\\/09\\\/Unpivot-Table-in-Power-BI-3-8488367.png\",\"width\":1181,\"height\":731,\"caption\":\"unpivot-table-in-power-bi-3-8488367-4091926-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":"Override pivot table in Power BI - R Marketing Digital","description":"The Unpivot table option in Power BI converts selected columns to rows. Let&#039;s see how to create Unpivot table or how to convert table","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\/anular-tabla-dinamica-en-power-bi\/","og_locale":"en_US","og_type":"article","og_title":"Anular tabla din\u00e1mica en Power BI","og_description":"La opci\u00f3n de tabla Unpivot de Power BI convierte las columnas seleccionadas en filas. Veamos c\u00f3mo crear una tabla Unpivot o c\u00f3mo convertir la tabla","og_url":"https:\/\/rmarketingdigital.com\/en\/powerbi\/anular-tabla-dinamica-en-power-bi\/","og_site_name":"R Marketing Digital","article_published_time":"2022-07-11T21:32:02+00:00","og_image":[{"width":1181,"height":731,"url":"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-3-8488367.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\/anular-tabla-dinamica-en-power-bi\/#article","isPartOf":{"@id":"https:\/\/rmarketingdigital.com\/powerbi\/anular-tabla-dinamica-en-power-bi\/"},"author":{"name":"R Marketing Digital","@id":"https:\/\/rmarketingdigital.com\/#\/schema\/person\/7c0d9782b2977b840b3740f00c69a73e"},"headline":"Anular tabla din\u00e1mica en Power BI","datePublished":"2022-07-11T21:32:02+00:00","mainEntityOfPage":{"@id":"https:\/\/rmarketingdigital.com\/powerbi\/anular-tabla-dinamica-en-power-bi\/"},"wordCount":346,"image":{"@id":"https:\/\/rmarketingdigital.com\/powerbi\/anular-tabla-dinamica-en-power-bi\/#primaryimage"},"thumbnailUrl":"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-3-8488367.png","articleSection":["Power BI","Tutoriales PowerBI"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/rmarketingdigital.com\/powerbi\/anular-tabla-dinamica-en-power-bi\/","url":"https:\/\/rmarketingdigital.com\/powerbi\/anular-tabla-dinamica-en-power-bi\/","name":"Override pivot table in Power BI - R Marketing Digital","isPartOf":{"@id":"https:\/\/rmarketingdigital.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/rmarketingdigital.com\/powerbi\/anular-tabla-dinamica-en-power-bi\/#primaryimage"},"image":{"@id":"https:\/\/rmarketingdigital.com\/powerbi\/anular-tabla-dinamica-en-power-bi\/#primaryimage"},"thumbnailUrl":"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-3-8488367.png","datePublished":"2022-07-11T21:32:02+00:00","author":{"@id":"https:\/\/rmarketingdigital.com\/#\/schema\/person\/7c0d9782b2977b840b3740f00c69a73e"},"description":"The Unpivot table option in Power BI converts selected columns to rows. Let&#039;s see how to create Unpivot table or how to convert table","inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/rmarketingdigital.com\/powerbi\/anular-tabla-dinamica-en-power-bi\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/rmarketingdigital.com\/powerbi\/anular-tabla-dinamica-en-power-bi\/#primaryimage","url":"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-3-8488367.png","contentUrl":"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Unpivot-Table-in-Power-BI-3-8488367.png","width":1181,"height":731,"caption":"unpivot-table-in-power-bi-3-8488367-4091926-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\/84848","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=84848"}],"version-history":[{"count":0,"href":"https:\/\/rmarketingdigital.com\/en\/wp-json\/wp\/v2\/posts\/84848\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/rmarketingdigital.com\/en\/wp-json\/wp\/v2\/media\/84847"}],"wp:attachment":[{"href":"https:\/\/rmarketingdigital.com\/en\/wp-json\/wp\/v2\/media?parent=84848"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rmarketingdigital.com\/en\/wp-json\/wp\/v2\/categories?post=84848"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rmarketingdigital.com\/en\/wp-json\/wp\/v2\/tags?post=84848"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}