{"id":84699,"date":"2022-10-02T21:37:05","date_gmt":"2022-10-02T19:37:05","guid":{"rendered":"https:\/\/rmarketingdigital.com\/powerbi\/tabla-dinamica-de-power-bi\/"},"modified":"2020-09-17T14:45:02","modified_gmt":"2020-09-17T17:45:02","slug":"tabla-dinamica-de-power-bi","status":"publish","type":"post","link":"https:\/\/rmarketingdigital.com\/de\/energiebi\/tabla-dinamica-de-power-bi\/","title":{"rendered":"Power BI-Pivot-Tabelle"},"content":{"rendered":"<div>\n<p>Die Option PivotTable in Power BI konvertiert ausgew\u00e4hlte Zeilen in Spalten. Lassen Sie mich Ihnen anhand eines Beispiels zeigen, wie Sie eine Pivot-Tabelle erstellen oder eine Nicht-Pivot-Tabelle in eine Pivot-Tabelle in Power BI konvertieren.<\/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>So erstellen Sie eine Power BI-Pivot-Tabelle<\/h2>\n<p>Klicken Sie auf, um eine Power BI-Pivot-Tabelle zu erstellen oder eine \u00c4nderung in eine Pivot-Tabelle zu konvertieren <b>Abfragen bearbeiten<\/b> Option unter der <b>Zuhause<\/b> Zunge.<\/p>\n<figure class=\"wp-block-image\"><img alt='Pivot-Table-in-Power-Bi-1-3672494' width='1009' height='614' class=\"wp-image-30947\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Pivot-Table-in-Power-BI-1-3672494.png 1009w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Pivot-Table-in-Power-BI-1-3672494-300x183.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Pivot-Table-in-Power-BI-1-3672494-768x467.png 768w' data-lazy-sizes='(max-width: 1009px) 100vw, 1009px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Pivot-Table-in-Power-BI-1-3672494.png'\/><noscript><img alt='Pivot-Table-in-Power-Bi-1-3672494' width='1009' height='614' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Pivot-Table-in-Power-BI-1-3672494.png' class=\"wp-image-30947\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Pivot-Table-in-Power-BI-1-3672494.png 1009w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Pivot-Table-in-Power-BI-1-3672494-300x183.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Pivot-Table-in-Power-BI-1-3672494-768x467.png 768w' sizes='(max-width: 1009px) 100vw, 1009px'\/><\/noscript><\/figure>\n<p>Klicken Sie auf <strong>Abfragen bearbeiten<\/strong> Die Option \u00f6ffnet ein neues Fenster mit dem Namen 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\"\/><\/span><\/p>\n<p>In diesem Beispiel drehen wir die Spalte f\u00fcr das Kalenderjahr basierend auf der Bestellmenge.<\/p>\n<figure class=\"wp-block-image\"><img alt='Pivot-Table-in-Power-Bi-2-7769779' width='1006' height='756' class=\"wp-image-30948\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Pivot-Table-in-Power-BI-2-7769779.png 1006w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Pivot-Table-in-Power-BI-2-7769779-300x225.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Pivot-Table-in-Power-BI-2-7769779-768x577.png 768w' data-lazy-sizes='(max-width: 1006px) 100vw, 1006px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Pivot-Table-in-Power-BI-2-7769779.png'\/><noscript><img alt='Pivot-Table-in-Power-Bi-2-7769779' width='1006' height='756' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Pivot-Table-in-Power-BI-2-7769779.png' class=\"wp-image-30948\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Pivot-Table-in-Power-BI-2-7769779.png 1006w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Pivot-Table-in-Power-BI-2-7769779-300x225.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Pivot-Table-in-Power-BI-2-7769779-768x577.png 768w' sizes='(max-width: 1006px) 100vw, 1006px'\/><\/noscript><\/figure>\n<p>Um die Tabelle ohne Unterteilungen in eine Pivot-Tabelle zu konvertieren, gehen Sie zu <strong>Verwandeln<\/strong> Zunge. Auf dieser Registerkarte finden Sie die <strong>Schwenks\u00e4ule<\/strong> Taste wie unten gezeigt.<\/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='Pivot-Table-in-Power-Bi-3-9924004' width='1286' height='738' class=\"wp-image-30949\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Pivot-Table-in-Power-BI-3-9924004.png 1286w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Pivot-Table-in-Power-BI-3-9924004-300x172.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Pivot-Table-in-Power-BI-3-9924004-1024x588.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Pivot-Table-in-Power-BI-3-9924004-768x441.png 768w' data-lazy-sizes='(max-width: 1286px) 100vw, 1286px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Pivot-Table-in-Power-BI-3-9924004.png'\/><noscript><img alt='Pivot-Table-in-Power-Bi-3-9924004' width='1286' height='738' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Pivot-Table-in-Power-BI-3-9924004.png' class=\"wp-image-30949\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Pivot-Table-in-Power-BI-3-9924004.png 1286w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Pivot-Table-in-Power-BI-3-9924004-300x172.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Pivot-Table-in-Power-BI-3-9924004-1024x588.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Pivot-Table-in-Power-BI-3-9924004-768x441.png 768w' sizes='(max-width: 1286px) 100vw, 1286px'\/><\/noscript><\/figure>\n<p>Durch Klicken auf die Schaltfl\u00e4che Dynamische Spalte wird das folgende Fenster ge\u00f6ffnet.<\/p>\n<figure class=\"wp-block-image\"><img alt='Pivot-Table-in-Power-Bi-4-7678927' width='700' height='272' class=\"wp-image-30950\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Pivot-Table-in-Power-BI-4-7678927.png 700w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Pivot-Table-in-Power-BI-4-7678927-300x117.png 300w' data-lazy-sizes='(max-width: 700px) 100vw, 700px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Pivot-Table-in-Power-BI-4-7678927.png'\/><noscript><img alt='Pivot-Table-in-Power-Bi-4-7678927' width='700' height='272' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Pivot-Table-in-Power-BI-4-7678927.png' class=\"wp-image-30950\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Pivot-Table-in-Power-BI-4-7678927.png 700w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Pivot-Table-in-Power-BI-4-7678927-300x117.png 300w' sizes='(max-width: 700px) 100vw, 700px'\/><\/noscript><\/figure>\n<p>Lassen Sie mich die Bestellmenge als Wertespalte ausw\u00e4hlen<\/p>\n<figure class=\"wp-block-image\"><img alt='Pivot-Table-in-Power-Bi-5-9242498' width='699' height='314' class=\"wp-image-30951\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Pivot-Table-in-Power-BI-5-9242498.png 699w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Pivot-Table-in-Power-BI-5-9242498-300x135.png 300w' data-lazy-sizes='(max-width: 699px) 100vw, 699px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Pivot-Table-in-Power-BI-5-9242498.png'\/><noscript><img alt='Pivot-Table-in-Power-Bi-5-9242498' width='699' height='314' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Pivot-Table-in-Power-BI-5-9242498.png' class=\"wp-image-30951\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Pivot-Table-in-Power-BI-5-9242498.png 699w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Pivot-Table-in-Power-BI-5-9242498-300x135.png 300w' sizes='(max-width: 699px) 100vw, 699px'\/><\/noscript><\/figure>\n<p>Als n\u00e4chstes w\u00e4hlen wir die Summe als Wert der Aggregatfunktion aus<\/p>\n<figure class=\"wp-block-image\"><img alt='Pivot-Table-in-Power-Bi-6-7520588' width='700' height='314' class=\"wp-image-30952\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Pivot-Table-in-Power-BI-6-7520588.png 700w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Pivot-Table-in-Power-BI-6-7520588-300x135.png 300w' data-lazy-sizes='(max-width: 700px) 100vw, 700px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Pivot-Table-in-Power-BI-6-7520588.png'\/><noscript><img alt='Pivot-Table-in-Power-Bi-6-7520588' width='700' height='314' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Pivot-Table-in-Power-BI-6-7520588.png' class=\"wp-image-30952\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Pivot-Table-in-Power-BI-6-7520588.png 700w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Pivot-Table-in-Power-BI-6-7520588-300x135.png 300w' sizes='(max-width: 700px) 100vw, 700px'\/><\/noscript><\/figure>\n<p>Jetzt k\u00f6nnen Sie die Pivot-Tabelle sehen<\/p>\n<figure class=\"wp-block-image\"><img alt='Pivot-Table-in-Power-Bi-7-7994216' width='1068' height='738' class=\"wp-image-30953\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Pivot-Table-in-Power-BI-7-7994216.png 1068w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Pivot-Table-in-Power-BI-7-7994216-300x207.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Pivot-Table-in-Power-BI-7-7994216-1024x708.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Pivot-Table-in-Power-BI-7-7994216-768x531.png 768w' data-lazy-sizes='(max-width: 1068px) 100vw, 1068px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Pivot-Table-in-Power-BI-7-7994216.png'\/><noscript><img alt='Pivot-Table-in-Power-Bi-7-7994216' width='1068' height='738' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Pivot-Table-in-Power-BI-7-7994216.png' class=\"wp-image-30953\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Pivot-Table-in-Power-BI-7-7994216.png 1068w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Pivot-Table-in-Power-BI-7-7994216-300x207.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Pivot-Table-in-Power-BI-7-7994216-1024x708.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Pivot-Table-in-Power-BI-7-7994216-768x531.png 768w' sizes='(max-width: 1068px) 100vw, 1068px'\/><\/noscript><\/figure>\n<p>Was ist, wenn Ihre Tabelle mehr als eine statische Spalte enth\u00e4lt (eine Spalte, die sich beim Schwenken nicht \u00e4ndert)? Dazu f\u00fcgen wir dieser Tabelle eine weitere Spalte mit dem Namen Produkt-ID hinzu.<\/p>\n<figure class=\"wp-block-image\"><img alt='Pivot-Table-in-Power-Bi-8-2271357' width='1276' height='731' class=\"wp-image-30954\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Pivot-Table-in-Power-BI-8-2271357.png 1276w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Pivot-Table-in-Power-BI-8-2271357-300x172.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Pivot-Table-in-Power-BI-8-2271357-1024x587.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Pivot-Table-in-Power-BI-8-2271357-768x440.png 768w' data-lazy-sizes='(max-width: 1276px) 100vw, 1276px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Pivot-Table-in-Power-BI-8-2271357.png'\/><noscript><img alt='Pivot-Table-in-Power-Bi-8-2271357' width='1276' height='731' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Pivot-Table-in-Power-BI-8-2271357.png' class=\"wp-image-30954\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Pivot-Table-in-Power-BI-8-2271357.png 1276w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Pivot-Table-in-Power-BI-8-2271357-300x172.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Pivot-Table-in-Power-BI-8-2271357-1024x587.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Pivot-Table-in-Power-BI-8-2271357-768x440.png 768w' sizes='(max-width: 1276px) 100vw, 1276px'\/><\/noscript><\/figure>\n<p>Lassen Sie mich die Spalte Bestellmenge als Wertespalte und Summe als Aggregatfunktion ausw\u00e4hlen<\/p>\n<figure class=\"wp-block-image\"><img alt='Pivot-Table-in-Power-Bi-9-7799314' width='700' height='314' class=\"wp-image-30955\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Pivot-Table-in-Power-BI-9-7799314.png 700w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Pivot-Table-in-Power-BI-9-7799314-300x135.png 300w' data-lazy-sizes='(max-width: 700px) 100vw, 700px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Pivot-Table-in-Power-BI-9-7799314.png'\/><noscript><img alt='Pivot-Table-in-Power-Bi-9-7799314' width='700' height='314' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Pivot-Table-in-Power-BI-9-7799314.png' class=\"wp-image-30955\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Pivot-Table-in-Power-BI-9-7799314.png 700w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Pivot-Table-in-Power-BI-9-7799314-300x135.png 300w' sizes='(max-width: 700px) 100vw, 700px'\/><\/noscript><\/figure>\n<p>Jetzt k\u00f6nnen Sie die Pivot-Tabelle in Power BI sehen. Denken Sie daran, dass mehr als eine statische Spalte ohne \u00c4nderungen beim Erstellen einer Pivot-Tabelle keinen Unterschied macht.<\/p>\n<figure class=\"wp-block-image\"><img alt='Pivot-Table-in-Power-Bi-10-4739040' width='1157' height='730' class=\"wp-image-30956\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Pivot-Table-in-Power-BI-10-4739040.png 1157w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Pivot-Table-in-Power-BI-10-4739040-300x189.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Pivot-Table-in-Power-BI-10-4739040-1024x646.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Pivot-Table-in-Power-BI-10-4739040-768x485.png 768w' data-lazy-sizes='(max-width: 1157px) 100vw, 1157px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Pivot-Table-in-Power-BI-10-4739040.png'\/><noscript><img alt='Pivot-Table-in-Power-Bi-10-4739040' width='1157' height='730' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Pivot-Table-in-Power-BI-10-4739040.png' class=\"wp-image-30956\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Pivot-Table-in-Power-BI-10-4739040.png 1157w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Pivot-Table-in-Power-BI-10-4739040-300x189.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Pivot-Table-in-Power-BI-10-4739040-1024x646.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Pivot-Table-in-Power-BI-10-4739040-768x485.png 768w' sizes='(max-width: 1157px) 100vw, 1157px'\/><\/noscript><\/figure>\n<p>Dr\u00fccken Sie dann die <strong>Schlie\u00dfen und anwenden <\/strong>Option unter der <strong>Zuhause<\/strong> Registerkarte, um diese \u00c4nderungen zu \u00fcbernehmen.<\/p>\n<figure class=\"wp-block-image\"><img alt='Pivot-Table-in-Power-Bi-11-4622104' width='1157' height='732' class=\"wp-image-30957\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Pivot-Table-in-Power-BI-11-4622104.png 1157w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Pivot-Table-in-Power-BI-11-4622104-300x190.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Pivot-Table-in-Power-BI-11-4622104-1024x648.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Pivot-Table-in-Power-BI-11-4622104-768x486.png 768w' data-lazy-sizes='(max-width: 1157px) 100vw, 1157px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Pivot-Table-in-Power-BI-11-4622104.png'\/><noscript><img alt='Pivot-Table-in-Power-Bi-11-4194522' width='1157' height='732' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Pivot-Table-in-Power-BI-11-4194522.png' class=\"wp-image-30957\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Pivot-Table-in-Power-BI-11-4194522.png 1157w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Pivot-Table-in-Power-BI-11-4194522-300x190.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Pivot-Table-in-Power-BI-11-4194522-1024x648.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Pivot-Table-in-Power-BI-11-4194522-768x486.png 768w' sizes='(max-width: 1157px) 100vw, 1157px'\/><\/noscript><\/figure>\n<p>Im folgenden Screenshot sehen Sie die dynamischen Spalten.<\/p>\n<figure class=\"wp-block-image\"><img alt='Pivot-Table-in-Power-Bi-12-5153738' width='1057' height='626' class=\"wp-image-30958\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Pivot-Table-in-Power-BI-12-5153738.png 1057w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Pivot-Table-in-Power-BI-12-5153738-300x178.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Pivot-Table-in-Power-BI-12-5153738-1024x606.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Pivot-Table-in-Power-BI-12-5153738-768x455.png 768w' data-lazy-sizes='(max-width: 1057px) 100vw, 1057px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Pivot-Table-in-Power-BI-12-5153738.png'\/><noscript><img alt='Pivot-Table-in-Power-Bi-12-5899958' width='1057' height='626' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Pivot-Table-in-Power-BI-12-5899958.png' class=\"wp-image-30958\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Pivot-Table-in-Power-BI-12-5899958.png 1057w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Pivot-Table-in-Power-BI-12-5899958-300x178.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Pivot-Table-in-Power-BI-12-5899958-1024x606.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Pivot-Table-in-Power-BI-12-5899958-768x455.png 768w' sizes='(max-width: 1057px) 100vw, 1057px'\/><\/noscript><\/figure>\n<\/div>","protected":false},"excerpt":{"rendered":"<p>Die Power BI-PivotTable-Option konvertiert ausgew\u00e4hlte Zeilen in Spalten. Lassen Sie mich Ihnen zeigen, wie Sie eine Pivot-Tabelle erstellen oder die Nicht-Pivot-Tabelle in eine ...<\/p>","protected":false},"author":1,"featured_media":84698,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1359,1360],"tags":[],"class_list":["post-84699","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>Tabla din\u00e1mica de Power BI - R Marketing Digital<\/title>\n<meta name=\"description\" content=\"La opci\u00f3n de tabla din\u00e1mica de Power BI convierte las filas seleccionadas en columnas. Perm\u00edtame mostrarle c\u00f3mo crear una tabla din\u00e1mica o c\u00f3mo convertir\" \/>\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\/de\/energiebi\/tabla-dinamica-de-power-bi\/\" \/>\n<meta property=\"og:locale\" content=\"de_DE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Tabla din\u00e1mica de Power BI\" \/>\n<meta property=\"og:description\" content=\"La opci\u00f3n de tabla din\u00e1mica de Power BI convierte las filas seleccionadas en columnas. Perm\u00edtame mostrarle c\u00f3mo crear una tabla din\u00e1mica o c\u00f3mo convertir\" \/>\n<meta property=\"og:url\" content=\"https:\/\/rmarketingdigital.com\/de\/energiebi\/tabla-dinamica-de-power-bi\/\" \/>\n<meta property=\"og:site_name\" content=\"R Marketing Digital\" \/>\n<meta property=\"article:published_time\" content=\"2022-10-02T19:37:05+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Pivot-Table-in-Power-BI-5-9839396.png\" \/>\n\t<meta property=\"og:image:width\" content=\"699\" \/>\n\t<meta property=\"og:image:height\" content=\"314\" \/>\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\\\/tabla-dinamica-de-power-bi\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/tabla-dinamica-de-power-bi\\\/\"},\"author\":{\"name\":\"R Marketing Digital\",\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/#\\\/schema\\\/person\\\/7c0d9782b2977b840b3740f00c69a73e\"},\"headline\":\"Tabla din\u00e1mica de Power BI\",\"datePublished\":\"2022-10-02T19:37:05+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/tabla-dinamica-de-power-bi\\\/\"},\"wordCount\":330,\"image\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/tabla-dinamica-de-power-bi\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/rmarketingdigital.com\\\/wp-content\\\/uploads\\\/2020\\\/09\\\/Pivot-Table-in-Power-BI-5-9839396.png\",\"articleSection\":[\"Power BI\",\"Tutoriales PowerBI\"],\"inLanguage\":\"de\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/tabla-dinamica-de-power-bi\\\/\",\"url\":\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/tabla-dinamica-de-power-bi\\\/\",\"name\":\"Tabla din\u00e1mica de Power BI - R Marketing Digital\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/tabla-dinamica-de-power-bi\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/tabla-dinamica-de-power-bi\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/rmarketingdigital.com\\\/wp-content\\\/uploads\\\/2020\\\/09\\\/Pivot-Table-in-Power-BI-5-9839396.png\",\"datePublished\":\"2022-10-02T19:37:05+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/#\\\/schema\\\/person\\\/7c0d9782b2977b840b3740f00c69a73e\"},\"description\":\"La opci\u00f3n de tabla din\u00e1mica de Power BI convierte las filas seleccionadas en columnas. Perm\u00edtame mostrarle c\u00f3mo crear una tabla din\u00e1mica o c\u00f3mo convertir\",\"inLanguage\":\"de\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/tabla-dinamica-de-power-bi\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/tabla-dinamica-de-power-bi\\\/#primaryimage\",\"url\":\"https:\\\/\\\/rmarketingdigital.com\\\/wp-content\\\/uploads\\\/2020\\\/09\\\/Pivot-Table-in-Power-BI-5-9839396.png\",\"contentUrl\":\"https:\\\/\\\/rmarketingdigital.com\\\/wp-content\\\/uploads\\\/2020\\\/09\\\/Pivot-Table-in-Power-BI-5-9839396.png\",\"width\":699,\"height\":314,\"caption\":\"pivot-table-in-power-bi-5-9839396-2720701-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\":\"de\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/#\\\/schema\\\/person\\\/7c0d9782b2977b840b3740f00c69a73e\",\"name\":\"R Marketing Digital\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@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":"Pivot-Tabelle von Power BI - R Marketing Digital","description":"Die Option PivotTable in Power BI konvertiert ausgew\u00e4hlte Zeilen in Spalten. Lassen Sie mich Ihnen zeigen, wie Sie eine Pivot-Tabelle erstellen oder konvertieren","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\/de\/energiebi\/tabla-dinamica-de-power-bi\/","og_locale":"de_DE","og_type":"article","og_title":"Tabla din\u00e1mica de Power BI","og_description":"La opci\u00f3n de tabla din\u00e1mica de Power BI convierte las filas seleccionadas en columnas. Perm\u00edtame mostrarle c\u00f3mo crear una tabla din\u00e1mica o c\u00f3mo convertir","og_url":"https:\/\/rmarketingdigital.com\/de\/energiebi\/tabla-dinamica-de-power-bi\/","og_site_name":"R Marketing Digital","article_published_time":"2022-10-02T19:37:05+00:00","og_image":[{"width":699,"height":314,"url":"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Pivot-Table-in-Power-BI-5-9839396.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\/tabla-dinamica-de-power-bi\/#article","isPartOf":{"@id":"https:\/\/rmarketingdigital.com\/powerbi\/tabla-dinamica-de-power-bi\/"},"author":{"name":"R Marketing Digital","@id":"https:\/\/rmarketingdigital.com\/#\/schema\/person\/7c0d9782b2977b840b3740f00c69a73e"},"headline":"Tabla din\u00e1mica de Power BI","datePublished":"2022-10-02T19:37:05+00:00","mainEntityOfPage":{"@id":"https:\/\/rmarketingdigital.com\/powerbi\/tabla-dinamica-de-power-bi\/"},"wordCount":330,"image":{"@id":"https:\/\/rmarketingdigital.com\/powerbi\/tabla-dinamica-de-power-bi\/#primaryimage"},"thumbnailUrl":"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Pivot-Table-in-Power-BI-5-9839396.png","articleSection":["Power BI","Tutoriales PowerBI"],"inLanguage":"de"},{"@type":"WebPage","@id":"https:\/\/rmarketingdigital.com\/powerbi\/tabla-dinamica-de-power-bi\/","url":"https:\/\/rmarketingdigital.com\/powerbi\/tabla-dinamica-de-power-bi\/","name":"Pivot-Tabelle von Power BI - R Marketing Digital","isPartOf":{"@id":"https:\/\/rmarketingdigital.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/rmarketingdigital.com\/powerbi\/tabla-dinamica-de-power-bi\/#primaryimage"},"image":{"@id":"https:\/\/rmarketingdigital.com\/powerbi\/tabla-dinamica-de-power-bi\/#primaryimage"},"thumbnailUrl":"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Pivot-Table-in-Power-BI-5-9839396.png","datePublished":"2022-10-02T19:37:05+00:00","author":{"@id":"https:\/\/rmarketingdigital.com\/#\/schema\/person\/7c0d9782b2977b840b3740f00c69a73e"},"description":"Die Option PivotTable in Power BI konvertiert ausgew\u00e4hlte Zeilen in Spalten. Lassen Sie mich Ihnen zeigen, wie Sie eine Pivot-Tabelle erstellen oder konvertieren","inLanguage":"de","potentialAction":[{"@type":"ReadAction","target":["https:\/\/rmarketingdigital.com\/powerbi\/tabla-dinamica-de-power-bi\/"]}]},{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/rmarketingdigital.com\/powerbi\/tabla-dinamica-de-power-bi\/#primaryimage","url":"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Pivot-Table-in-Power-BI-5-9839396.png","contentUrl":"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Pivot-Table-in-Power-BI-5-9839396.png","width":699,"height":314,"caption":"pivot-table-in-power-bi-5-9839396-2720701-png"},{"@type":"WebSite","@id":"https:\/\/rmarketingdigital.com\/#website","url":"https:\/\/rmarketingdigital.com\/","name":"R Digitales Marketing","description":"SEO Agentur | Werbung f\u00fcr soziale Netzwerke | 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":"de"},{"@type":"Person","@id":"https:\/\/rmarketingdigital.com\/#\/schema\/person\/7c0d9782b2977b840b3740f00c69a73e","name":"R Digitales Marketing","image":{"@type":"ImageObject","inLanguage":"de","@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\/de\/wp-json\/wp\/v2\/posts\/84699","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/rmarketingdigital.com\/de\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/rmarketingdigital.com\/de\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/rmarketingdigital.com\/de\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/rmarketingdigital.com\/de\/wp-json\/wp\/v2\/comments?post=84699"}],"version-history":[{"count":0,"href":"https:\/\/rmarketingdigital.com\/de\/wp-json\/wp\/v2\/posts\/84699\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/rmarketingdigital.com\/de\/wp-json\/wp\/v2\/media\/84698"}],"wp:attachment":[{"href":"https:\/\/rmarketingdigital.com\/de\/wp-json\/wp\/v2\/media?parent=84699"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rmarketingdigital.com\/de\/wp-json\/wp\/v2\/categories?post=84699"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rmarketingdigital.com\/de\/wp-json\/wp\/v2\/tags?post=84699"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}