{"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\/fr\/puissancebi\/tabla-dinamica-de-power-bi\/","title":{"rendered":"Tableau crois\u00e9 dynamique Power BI"},"content":{"rendered":"<div>\n<p>L&#039;option de tableau crois\u00e9 dynamique dans Power BI convertit les lignes s\u00e9lectionn\u00e9es en colonnes. Permettez-moi de vous montrer comment cr\u00e9er un tableau crois\u00e9 dynamique ou convertir un tableau non crois\u00e9 dynamique en tableau crois\u00e9 dynamique dans Power BI avec un exemple.<\/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>Comment cr\u00e9er un tableau crois\u00e9 dynamique Power BI<\/h2>\n<p>Pour cr\u00e9er un tableau crois\u00e9 dynamique Power BI ou convertir une modification en tableau crois\u00e9 dynamique, cliquez sur l&#039;ic\u00f4ne <b>Modifier les requ\u00eates<\/b> option sous le <b>foyer<\/b> langue.<\/p>\n<figure class=\"wp-block-image\"><img alt='table-pivot-en-puissance-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='table-pivot-en-puissance-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>En cliquant <strong>Modifier les requ\u00eates<\/strong> L&#039;option ouvre une nouvelle fen\u00eatre appel\u00e9e Power BI <strong>\u00c9diteur Power Query<\/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>Dans cet exemple, nous allons faire pivoter la colonne de l&#039;ann\u00e9e civile en fonction de la quantit\u00e9 command\u00e9e.<\/p>\n<figure class=\"wp-block-image\"><img alt='table-pivot-en-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='table-pivot-en-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>Pour convertir le tableau sans divisions en tableau crois\u00e9 dynamique, acc\u00e9dez \u00e0 <strong>Transformer<\/strong> Langue. Dans cet onglet, vous pouvez trouver le <strong>colonne pivot<\/strong> comme indiqu\u00e9 ci-dessous.<\/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='table-pivot-en-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='table-pivot-en-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>Cliquez sur le bouton Colonne dynamique pour ouvrir la fen\u00eatre suivante.<\/p>\n<figure class=\"wp-block-image\"><img alt='table-pivot-en-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='table-pivot-en-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>Permettez-moi de s\u00e9lectionner la quantit\u00e9 command\u00e9e comme colonne de valeur<\/p>\n<figure class=\"wp-block-image\"><img alt='table-pivot-en-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='table-pivot-en-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>Ensuite, nous s\u00e9lectionnons la somme comme valeur de la fonction d&#039;agr\u00e9gation<\/p>\n<figure class=\"wp-block-image\"><img alt='table-pivot-en-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='table-pivot-en-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>Vous pouvez maintenant voir le tableau crois\u00e9 dynamique<\/p>\n<figure class=\"wp-block-image\"><img alt='table-pivot-en-puissance-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='table-pivot-en-puissance-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>Que faire si votre table comporte plusieurs colonnes statiques (une colonne qui ne changera pas dans le processus de pivotement)? Pour cela, nous ajoutons une colonne suppl\u00e9mentaire appel\u00e9e Product Id \u00e0 ce tableau.<\/p>\n<figure class=\"wp-block-image\"><img alt='table-pivot-en-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='table-pivot-en-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>Permettez-moi de s\u00e9lectionner la colonne Quantit\u00e9 de commande comme colonne de valeur et Somme comme fonction d&#039;agr\u00e9gation<\/p>\n<figure class=\"wp-block-image\"><img alt='table-pivot-en-puissance-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='table-pivot-en-puissance-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>Vous pouvez maintenant voir le tableau crois\u00e9 dynamique dans Power BI. N&#039;oubliez pas que le fait d&#039;avoir plus d&#039;une colonne statique sans modifications ne fera aucune diff\u00e9rence dans la cr\u00e9ation d&#039;un tableau crois\u00e9 dynamique.<\/p>\n<figure class=\"wp-block-image\"><img alt='table-pivot-en-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='table-pivot-en-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>Appuyez ensuite sur le <strong>Fermer et appliquer <\/strong>option sous le <strong>foyer<\/strong> onglet pour appliquer ces modifications.<\/p>\n<figure class=\"wp-block-image\"><img alt='table-pivot-en-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='table-pivot-en-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>Dans la capture d&#039;\u00e9cran suivante, vous pouvez voir les colonnes dynamiques.<\/p>\n<figure class=\"wp-block-image\"><img alt='table-pivot-en-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='table-pivot-en-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>L\u2019option de tableau crois\u00e9 dynamique Power BI convertit les lignes s\u00e9lectionn\u00e9es en colonnes. Laissez-moi vous montrer comment cr\u00e9er un tableau crois\u00e9 dynamique ou comment convertir un tableau non crois\u00e9 en un seul\u2026<\/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\/fr\/puissancebi\/tabla-dinamica-de-power-bi\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\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\/fr\/puissancebi\/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\":\"fr-FR\"},{\"@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\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/tabla-dinamica-de-power-bi\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@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\":\"fr-FR\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/#\\\/schema\\\/person\\\/7c0d9782b2977b840b3740f00c69a73e\",\"name\":\"R Marketing Digital\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@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":"Tableau crois\u00e9 dynamique Power BI - R Marketing Digital","description":"L&#039;option de tableau crois\u00e9 dynamique dans Power BI convertit les lignes s\u00e9lectionn\u00e9es en colonnes. Laissez-moi vous montrer comment cr\u00e9er un tableau crois\u00e9 dynamique ou comment convertir","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\/fr\/puissancebi\/tabla-dinamica-de-power-bi\/","og_locale":"fr_FR","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\/fr\/puissancebi\/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":"fr-FR"},{"@type":"WebPage","@id":"https:\/\/rmarketingdigital.com\/powerbi\/tabla-dinamica-de-power-bi\/","url":"https:\/\/rmarketingdigital.com\/powerbi\/tabla-dinamica-de-power-bi\/","name":"Tableau crois\u00e9 dynamique 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":"L&#039;option de tableau crois\u00e9 dynamique dans Power BI convertit les lignes s\u00e9lectionn\u00e9es en colonnes. Laissez-moi vous montrer comment cr\u00e9er un tableau crois\u00e9 dynamique ou comment convertir","inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/rmarketingdigital.com\/powerbi\/tabla-dinamica-de-power-bi\/"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@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":"Marketing num\u00e9rique","description":"Agence de r\u00e9f\u00e9rencement | Publicit\u00e9 sur les r\u00e9seaux sociaux | Gestion de communaut\u00e9","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":"fr-FR"},{"@type":"Person","@id":"https:\/\/rmarketingdigital.com\/#\/schema\/person\/7c0d9782b2977b840b3740f00c69a73e","name":"Marketing num\u00e9rique","image":{"@type":"ImageObject","inLanguage":"fr-FR","@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\/fr\/wp-json\/wp\/v2\/posts\/84699","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/rmarketingdigital.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/rmarketingdigital.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/rmarketingdigital.com\/fr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/rmarketingdigital.com\/fr\/wp-json\/wp\/v2\/comments?post=84699"}],"version-history":[{"count":0,"href":"https:\/\/rmarketingdigital.com\/fr\/wp-json\/wp\/v2\/posts\/84699\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/rmarketingdigital.com\/fr\/wp-json\/wp\/v2\/media\/84698"}],"wp:attachment":[{"href":"https:\/\/rmarketingdigital.com\/fr\/wp-json\/wp\/v2\/media?parent=84699"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rmarketingdigital.com\/fr\/wp-json\/wp\/v2\/categories?post=84699"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rmarketingdigital.com\/fr\/wp-json\/wp\/v2\/tags?post=84699"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}