{"id":86508,"date":"2022-07-24T13:12:46","date_gmt":"2022-07-24T11:12:46","guid":{"rendered":"https:\/\/rmarketingdigital.com\/powerbi\/crear-grafico-de-columnas-100-apiladas-en-power-bi\/"},"modified":"2020-09-18T13:23:00","modified_gmt":"2020-09-18T16:23:00","slug":"crear-grafico-de-columnas-100-apiladas-en-power-bi","status":"publish","type":"post","link":"https:\/\/rmarketingdigital.com\/en\/powerbi\/crear-grafico-de-columnas-100-apiladas-en-power-bi\/","title":{"rendered":"Create stacked 100% column chart in Power BI"},"content":{"rendered":"<div>\n<p>The stacked 100% column chart in Power BI displays the metric information in percentages. Let me show you how to create a stacked 100% column chart 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\"\/><\/span><\/p>\n<p>For this Power BI 100% Stacked Column Chart demo, we will use the SQL data source that we created in our previous article. Therefore, see the article Connect Power BI to SQL Server to understand the Power BI data source.<\/p>\n<h2>How to create a stacked 100% column chart in Power BI<\/h2>\n<p>To create a stacked Power BI 100% column chart, first drag and drop the sales amount from the Fields section to the region of the canvas. Automatically create a column chart.<\/p>\n<figure class=\"wp-block-image\"><img alt='create-100-stacked-column-chart-in-power-bi-1-6482519' width='1245' height='681' class=\"wp-image-30066\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-1-6482519.png 1245w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-1-6482519-300x164.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-1-6482519-1024x560.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-1-6482519-768x420.png 768w' data-lazy-sizes='(max-width: 1245px) 100vw, 1245px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-1-6482519.png'\/><noscript><img alt='create-100-stacked-column-chart-in-power-bi-1-6482519' width='1245' height='681' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-1-6482519.png' class=\"wp-image-30066\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-1-6482519.png 1245w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-1-6482519-300x164.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-1-6482519-1024x560.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-1-6482519-768x420.png 768w' sizes='(max-width: 1245px) 100vw, 1245px'\/><\/noscript><\/figure>\n<p>Next, let me add the name of the sales territory region to the Hub section. This column chart shows the sales amount by sales territory region name.<\/p>\n<figure class=\"wp-block-image\"><img alt='create-100-stacked-column-chart-in-power-bi-2-2514865' width='1246' height='681' class=\"wp-image-30067\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-2-2514865.png 1246w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-2-2514865-300x164.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-2-2514865-1024x560.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-2-2514865-768x420.png 768w' data-lazy-sizes='(max-width: 1246px) 100vw, 1246px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-2-2514865.png'\/><noscript><img alt='create-100-stacked-column-chart-in-power-bi-2-2514865' width='1246' height='681' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-2-2514865.png' class=\"wp-image-30067\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-2-2514865.png 1246w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-2-2514865-300x164.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-2-2514865-1024x560.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-2-2514865-768x420.png 768w' sizes='(max-width: 1246px) 100vw, 1246px'\/><\/noscript><\/figure>\n<p>Click on the 100% column chart stacked below the <b>Display<\/b> section. Automatically converts column chart to stacked column chart by 100%.<\/p>\n<p><span id=\"ezoic-pub-ad-placeholder-105\"\/><span style=\"display:block !important;float:none !important;margin-bottom:15px !important;margin-left:0px !important;margin-right:0px !important;margin-top:15px !important;min-height:400px;min-width:580px;text-align:center !important;\" class=\"ezoic-ad box-4 adtester-container adtester-container-105\" data-ez-name=\"tutorialgateway_org-box-4\"><span id=\"div-gpt-ad-tutorialgateway_org-box-4-0\" ezaw=\"580\" ezah=\"400\" style=\"position:relative;z-index:0;display:inline-block;width:100%;max-width:1200px;margin-left:auto !important;margin-right:auto !important;min-height:400px;min-width:580px;\" class=\"ezoic-ad ezoic-adl\"\/><\/span><\/p>\n<figure class=\"wp-block-image\"><img alt='create-100-stacked-column-chart-in-power-bi-3-6740679' width='1245' height='682' class=\"wp-image-30068\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-3-6740679.png 1245w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-3-6740679-300x164.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-3-6740679-1024x561.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-3-6740679-768x421.png 768w' data-lazy-sizes='(max-width: 1245px) 100vw, 1245px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-3-6740679.png'\/><noscript><img alt='create-100-stacked-column-chart-in-power-bi-3-6740679' width='1245' height='682' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-3-6740679.png' class=\"wp-image-30068\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-3-6740679.png 1245w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-3-6740679-300x164.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-3-6740679-1024x561.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-3-6740679-768x421.png 768w' sizes='(max-width: 1245px) 100vw, 1245px'\/><\/noscript><\/figure>\n<p>Next, we will add Customer Occupancy to the Legend section to make it the stacked column chart at 100%.<\/p>\n<figure class=\"wp-block-image\"><img alt='create-100-stacked-column-chart-in-power-bi-4-7684515' width='1245' height='682' class=\"wp-image-30069\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-4-7684515.png 1245w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-4-7684515-300x164.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-4-7684515-1024x561.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-4-7684515-768x421.png 768w' data-lazy-sizes='(max-width: 1245px) 100vw, 1245px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-4-7684515.png'\/><noscript><img alt='create-100-stacked-column-chart-in-power-bi-4-7684515' width='1245' height='682' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-4-7684515.png' class=\"wp-image-30069\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-4-7684515.png 1245w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-4-7684515-300x164.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-4-7684515-1024x561.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-4-7684515-768x421.png 768w' sizes='(max-width: 1245px) 100vw, 1245px'\/><\/noscript><\/figure>\n<p>Hover over any part of a bar to display the tooltip for the sales territory region name, customer occupancy, and sales quantity (in percent)<\/p>\n<figure class=\"wp-block-image\"><img alt='create-100-stacked-column-chart-in-power-bi-5-1621056' width='1246' height='682' class=\"wp-image-30070\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-5-1621056.png 1246w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-5-1621056-300x164.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-5-1621056-1024x560.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-5-1621056-768x420.png 768w' data-lazy-sizes='(max-width: 1246px) 100vw, 1246px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-5-1621056.png'\/><noscript><img alt='create-100-stacked-column-chart-in-power-bi-5-1621056' width='1246' height='682' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-5-1621056.png' class=\"wp-image-30070\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-5-1621056.png 1246w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-5-1621056-300x164.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-5-1621056-1024x560.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-5-1621056-768x420.png 768w' sizes='(max-width: 1246px) 100vw, 1246px'\/><\/noscript><\/figure>\n<h3>Create stacked 100% column chart in Power BI approach 2<\/h3>\n<p>First, click on the 100% column chart stacked below the <b>Display<\/b> section. Automatically creates a 100% column chart stacked with dummy data, as shown in the following screenshot.<\/p>\n<figure class=\"wp-block-image\"><img alt='create-100-stacked-column-chart-in-power-bi-6-8677700' width='1246' height='681' class=\"wp-image-30071\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-6-8677700.png 1246w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-6-8677700-300x164.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-6-8677700-1024x560.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-6-8677700-768x420.png 768w' data-lazy-sizes='(max-width: 1246px) 100vw, 1246px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-6-8677700.png'\/><noscript><img alt='create-100-stacked-column-chart-in-power-bi-6-8677700' width='1246' height='681' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-6-8677700.png' class=\"wp-image-30071\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-6-8677700.png 1246w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-6-8677700-300x164.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-6-8677700-1024x560.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-6-8677700-768x420.png 768w' sizes='(max-width: 1246px) 100vw, 1246px'\/><\/noscript><\/figure>\n<p>To add data to the Power BI stacked column chart 100%, we have to add the required fields:<\/p>\n<ul>\n<li><b>Axis:<\/b> Specify the column that represents the vertical bars.<\/li>\n<li><b>Legend:<\/b> Specify the column to split the vertical bars.<\/li>\n<li><b>Values: <\/b>Any metric value, such as sales amount, total sales, etc.<\/li>\n<\/ul>\n<p>Let me drag the Sales Amount from the Fields section to the Values field and the Sales Territory Region Name field to the Axis Section.<\/p>\n<figure class=\"wp-block-image\"><img alt='create-100-stacked-column-chart-in-power-bi-7-8290574' width='1247' height='681' class=\"wp-image-30072\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-7-8290574.png 1247w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-7-8290574-300x164.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-7-8290574-1024x559.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-7-8290574-768x419.png 768w' data-lazy-sizes='(max-width: 1247px) 100vw, 1247px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-7-8290574.png'\/><noscript><img alt='create-100-stacked-column-chart-in-power-bi-7-8290574' width='1247' height='681' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-7-8290574.png' class=\"wp-image-30072\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-7-8290574.png 1247w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-7-8290574-300x164.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-7-8290574-1024x559.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-7-8290574-768x419.png 768w' sizes='(max-width: 1247px) 100vw, 1247px'\/><\/noscript><\/figure>\n<p>Then add the English Occupation from the DimCustomer table to the Legend section. You can do this by dragging Occupation to the Legend section, or simply check the Occupation column in English.<\/p>\n<figure class=\"wp-block-image\"><img alt='create-100-stacked-column-chart-in-power-bi-8-4865058' width='1245' height='681' class=\"wp-image-30073\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-8-4865058.png 1245w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-8-4865058-300x164.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-8-4865058-1024x560.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-8-4865058-768x420.png 768w' data-lazy-sizes='(max-width: 1245px) 100vw, 1245px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-8-4865058.png'\/><noscript><img alt='create-100-stacked-column-chart-in-power-bi-8-4865058' width='1245' height='681' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-8-4865058.png' class=\"wp-image-30073\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-8-4865058.png 1245w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-8-4865058-300x164.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-8-4865058-1024x560.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-8-4865058-768x420.png 768w' sizes='(max-width: 1245px) 100vw, 1245px'\/><\/noscript><\/figure>\n<p>In Power BI charts, data labels display information about each individual group in a vertical bar (sales territory region). In this case, it shows the Sales Amount (in percentage) for each occupation. Let me enable data labels so you can see the percentage of each group.<\/p>\n<p>To enable data labels, go to <strong>Format<\/strong> tab and toggle <strong>Data labels<\/strong> option a <strong>In<\/strong>. Let me change the color to white, the font family to DIN, and the text size to 20<\/p>\n<p>You can now see a 100% column chart stacked with percentage values<\/p>\n<figure class=\"wp-block-image\"><img alt='create-100-stacked-column-chart-in-power-bi-9-9874985' width='1222' height='748' class=\"wp-image-30074\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-9-9874985.png 1222w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-9-9874985-300x184.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-9-9874985-1024x627.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-9-9874985-768x470.png 768w' data-lazy-sizes='(max-width: 1222px) 100vw, 1222px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-9-9874985.png'\/><noscript><img alt='create-100-stacked-column-chart-in-power-bi-9-9874985' width='1222' height='748' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-9-9874985.png' class=\"wp-image-30074\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-9-9874985.png 1222w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-9-9874985-300x184.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-9-9874985-1024x627.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-9-9874985-768x470.png 768w' sizes='(max-width: 1222px) 100vw, 1222px'\/><\/noscript><\/figure>\n<p>Let me apply a quick format to this Power BI stacked 100% column chart<span id=\"ezoic-pub-ad-placeholder-106\" class=\"ezoic-adpicker-ad\"\/><span style=\"display:block !important;float:none;margin-bottom:15px !important;margin-left:0px !important;margin-right:0px !important;margin-top:15px !important;min-height:250px;min-width:300px;text-align:center !important;\" class=\"ezoic-ad banner-1 adtester-container adtester-container-106\" data-ez-name=\"tutorialgateway_org-banner-1\"><span id=\"div-gpt-ad-tutorialgateway_org-banner-1-0\" ezaw=\"300\" ezah=\"250\" style=\"position:relative;z-index:0;display:inline-block;min-height:250px;min-width:300px;\" class=\"ezoic-ad ezoic-adl\"\/><\/span><\/p>\n<p class=\"note\"><strong>NOTE:<\/strong> The formatting options for the stacked column chart and the stacked column chart to the 100% are the same. Therefore, I suggest that you refer to the Stacked Column Chart Format article to understand the steps required to format the stacked column chart properties to the 100%.<\/p>\n<figure class=\"wp-block-image\"><img alt='create-100-stacked-column-chart-in-power-bi-10-3847611' width='1255' height='774' class=\"wp-image-30075\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-10-3847611.png 1255w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-10-3847611-300x185.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-10-3847611-1024x632.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-10-3847611-768x474.png 768w' data-lazy-sizes='(max-width: 1255px) 100vw, 1255px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-10-3847611.png'\/><noscript><img alt='create-100-stacked-column-chart-in-power-bi-10-3847611' width='1255' height='774' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-10-3847611.png' class=\"wp-image-30075\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-10-3847611.png 1255w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-10-3847611-300x185.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-10-3847611-1024x632.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-10-3847611-768x474.png 768w' sizes='(max-width: 1255px) 100vw, 1255px'\/><\/noscript><\/figure>\n<p>This time, we added the name of the state province to the axis and the region of the sales territory to the legend to get a stacked column chart at 100%. In the screenshot below, you can see that the sales territory region acts as the color of the bar. This is because you cannot group the sales territory region within a state (state name inherited from territory).<\/p>\n<figure class=\"wp-block-image\"><img alt='create-100-stacked-column-chart-in-power-bi-11-8204534' width='1255' height='775' class=\"wp-image-30076\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-11-8204534.png 1255w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-11-8204534-300x185.png 300w' data-lazy-sizes='(max-width: 1255px) 100vw, 1255px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-11-8204534.png'\/><noscript><img alt='create-100-stacked-column-chart-in-power-bi-11-8204534' width='1255' height='775' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-11-8204534.png' class=\"wp-image-30076\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-11-8204534.png 1255w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-11-8204534-300x185.png 300w' sizes='(max-width: 1255px) 100vw, 1255px'\/><\/noscript><\/figure>\n<\/div>","protected":false},"excerpt":{"rendered":"<p>The Power BI 100% stacked column chart displays metric information in percentages. Let me show you how to create a 100% stacked column chart in Power BI\u2026<\/p>","protected":false},"author":1,"featured_media":86509,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1359,1360],"tags":[],"class_list":["post-86508","post","type-post","status-publish","format-standard","has-post-thumbnail","category-powerbi","category-tutoriales-power-bi"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.0 (Yoast SEO v28.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Crear gr\u00e1fico de columnas 100% apiladas en Power BI - R Marketing Digital<\/title>\n<meta name=\"description\" content=\"El gr\u00e1fico de columnas 100% apiladas de Power BI muestra la informaci\u00f3n de la m\u00e9trica en porcentajes. Perm\u00edtame mostrarle c\u00f3mo crear un gr\u00e1fico de\" \/>\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\/create-100-stacked-column-chart-in-power-bi\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Crear gr\u00e1fico de columnas 100% apiladas en Power BI\" \/>\n<meta property=\"og:description\" content=\"El gr\u00e1fico de columnas 100% apiladas de Power BI muestra la informaci\u00f3n de la m\u00e9trica en porcentajes. Perm\u00edtame mostrarle c\u00f3mo crear un gr\u00e1fico de\" \/>\n<meta property=\"og:url\" content=\"https:\/\/rmarketingdigital.com\/en\/powerbi\/create-100-stacked-column-chart-in-power-bi\/\" \/>\n<meta property=\"og:site_name\" content=\"R Marketing Digital\" \/>\n<meta property=\"article:published_time\" content=\"2022-07-24T11:12:46+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-10-3791898.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1255\" \/>\n\t<meta property=\"og:image:height\" content=\"774\" \/>\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\\\/fr\\\/powerbi\\\/create-100-stacked-column-chart-in-power-bi\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/fr\\\/powerbi\\\/create-100-stacked-column-chart-in-power-bi\\\/\"},\"author\":{\"name\":\"R Marketing Digital\",\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/#\\\/schema\\\/person\\\/7c0d9782b2977b840b3740f00c69a73e\"},\"headline\":\"Crear gr\u00e1fico de columnas 100% apiladas en Power BI\",\"datePublished\":\"2022-07-24T11:12:46+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/fr\\\/powerbi\\\/create-100-stacked-column-chart-in-power-bi\\\/\"},\"wordCount\":708,\"image\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/fr\\\/powerbi\\\/create-100-stacked-column-chart-in-power-bi\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/rmarketingdigital.com\\\/wp-content\\\/uploads\\\/2020\\\/09\\\/Create-100-Stacked-Column-Chart-in-Power-BI-10-3791898.png\",\"articleSection\":[\"Power BI\",\"Tutoriales PowerBI\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/fr\\\/powerbi\\\/create-100-stacked-column-chart-in-power-bi\\\/\",\"url\":\"https:\\\/\\\/rmarketingdigital.com\\\/fr\\\/powerbi\\\/create-100-stacked-column-chart-in-power-bi\\\/\",\"name\":\"Crear gr\u00e1fico de columnas 100% apiladas en Power BI - R Marketing Digital\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/fr\\\/powerbi\\\/create-100-stacked-column-chart-in-power-bi\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/fr\\\/powerbi\\\/create-100-stacked-column-chart-in-power-bi\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/rmarketingdigital.com\\\/wp-content\\\/uploads\\\/2020\\\/09\\\/Create-100-Stacked-Column-Chart-in-Power-BI-10-3791898.png\",\"datePublished\":\"2022-07-24T11:12:46+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/#\\\/schema\\\/person\\\/7c0d9782b2977b840b3740f00c69a73e\"},\"description\":\"El gr\u00e1fico de columnas 100% apiladas de Power BI muestra la informaci\u00f3n de la m\u00e9trica en porcentajes. Perm\u00edtame mostrarle c\u00f3mo crear un gr\u00e1fico de\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/rmarketingdigital.com\\\/fr\\\/powerbi\\\/create-100-stacked-column-chart-in-power-bi\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/fr\\\/powerbi\\\/create-100-stacked-column-chart-in-power-bi\\\/#primaryimage\",\"url\":\"https:\\\/\\\/rmarketingdigital.com\\\/wp-content\\\/uploads\\\/2020\\\/09\\\/Create-100-Stacked-Column-Chart-in-Power-BI-10-3791898.png\",\"contentUrl\":\"https:\\\/\\\/rmarketingdigital.com\\\/wp-content\\\/uploads\\\/2020\\\/09\\\/Create-100-Stacked-Column-Chart-in-Power-BI-10-3791898.png\",\"width\":1255,\"height\":774,\"caption\":\"create-100-stacked-column-chart-in-power-bi-10-3791898-9210577-png\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/#website\",\"url\":\"https:\\\/\\\/rmarketingdigital.com\\\/\",\"name\":\"R Marketing Digital\",\"description\":\"Agencia SEO | Publicidad redes sociales | Community Management\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/rmarketingdigital.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/#\\\/schema\\\/person\\\/7c0d9782b2977b840b3740f00c69a73e\",\"name\":\"R Marketing Digital\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/c5599c203e0120b8ccbff4666af86f35f9b3dcad468a8bc6295313a3964a80be?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/c5599c203e0120b8ccbff4666af86f35f9b3dcad468a8bc6295313a3964a80be?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/c5599c203e0120b8ccbff4666af86f35f9b3dcad468a8bc6295313a3964a80be?s=96&d=mm&r=g\",\"caption\":\"R Marketing Digital\"}}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Create 100% Stacked Column Chart in Power BI - R Marketing Digital","description":"The stacked 100% column chart in Power BI displays the metric information in percentages. Let me show you how to create a graph of","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\/create-100-stacked-column-chart-in-power-bi\/","og_locale":"en_US","og_type":"article","og_title":"Crear gr\u00e1fico de columnas 100% apiladas en Power BI","og_description":"El gr\u00e1fico de columnas 100% apiladas de Power BI muestra la informaci\u00f3n de la m\u00e9trica en porcentajes. Perm\u00edtame mostrarle c\u00f3mo crear un gr\u00e1fico de","og_url":"https:\/\/rmarketingdigital.com\/en\/powerbi\/create-100-stacked-column-chart-in-power-bi\/","og_site_name":"R Marketing Digital","article_published_time":"2022-07-24T11:12:46+00:00","og_image":[{"width":1255,"height":774,"url":"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-10-3791898.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\/fr\/powerbi\/create-100-stacked-column-chart-in-power-bi\/#article","isPartOf":{"@id":"https:\/\/rmarketingdigital.com\/fr\/powerbi\/create-100-stacked-column-chart-in-power-bi\/"},"author":{"name":"R Marketing Digital","@id":"https:\/\/rmarketingdigital.com\/#\/schema\/person\/7c0d9782b2977b840b3740f00c69a73e"},"headline":"Crear gr\u00e1fico de columnas 100% apiladas en Power BI","datePublished":"2022-07-24T11:12:46+00:00","mainEntityOfPage":{"@id":"https:\/\/rmarketingdigital.com\/fr\/powerbi\/create-100-stacked-column-chart-in-power-bi\/"},"wordCount":708,"image":{"@id":"https:\/\/rmarketingdigital.com\/fr\/powerbi\/create-100-stacked-column-chart-in-power-bi\/#primaryimage"},"thumbnailUrl":"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-10-3791898.png","articleSection":["Power BI","Tutoriales PowerBI"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/rmarketingdigital.com\/fr\/powerbi\/create-100-stacked-column-chart-in-power-bi\/","url":"https:\/\/rmarketingdigital.com\/fr\/powerbi\/create-100-stacked-column-chart-in-power-bi\/","name":"Create 100% Stacked Column Chart in Power BI - R Marketing Digital","isPartOf":{"@id":"https:\/\/rmarketingdigital.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/rmarketingdigital.com\/fr\/powerbi\/create-100-stacked-column-chart-in-power-bi\/#primaryimage"},"image":{"@id":"https:\/\/rmarketingdigital.com\/fr\/powerbi\/create-100-stacked-column-chart-in-power-bi\/#primaryimage"},"thumbnailUrl":"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-10-3791898.png","datePublished":"2022-07-24T11:12:46+00:00","author":{"@id":"https:\/\/rmarketingdigital.com\/#\/schema\/person\/7c0d9782b2977b840b3740f00c69a73e"},"description":"The stacked 100% column chart in Power BI displays the metric information in percentages. Let me show you how to create a graph of","inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/rmarketingdigital.com\/fr\/powerbi\/create-100-stacked-column-chart-in-power-bi\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/rmarketingdigital.com\/fr\/powerbi\/create-100-stacked-column-chart-in-power-bi\/#primaryimage","url":"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-10-3791898.png","contentUrl":"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Column-Chart-in-Power-BI-10-3791898.png","width":1255,"height":774,"caption":"create-100-stacked-column-chart-in-power-bi-10-3791898-9210577-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\/86508","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=86508"}],"version-history":[{"count":0,"href":"https:\/\/rmarketingdigital.com\/en\/wp-json\/wp\/v2\/posts\/86508\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/rmarketingdigital.com\/en\/wp-json\/wp\/v2\/media\/86509"}],"wp:attachment":[{"href":"https:\/\/rmarketingdigital.com\/en\/wp-json\/wp\/v2\/media?parent=86508"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rmarketingdigital.com\/en\/wp-json\/wp\/v2\/categories?post=86508"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rmarketingdigital.com\/en\/wp-json\/wp\/v2\/tags?post=86508"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}