{"id":86458,"date":"2022-05-23T03:17:37","date_gmt":"2022-05-23T01:17:37","guid":{"rendered":"https:\/\/rmarketingdigital.com\/powerbi\/crear-grafico-de-barras-100-apiladas-en-power-bi\/"},"modified":"2020-09-18T12:46:21","modified_gmt":"2020-09-18T15:46:21","slug":"crear-grafico-de-barras-100-apiladas-en-power-bi","status":"publish","type":"post","link":"https:\/\/rmarketingdigital.com\/en\/powerbi\/crear-grafico-de-barras-100-apiladas-en-power-bi\/","title":{"rendered":"Create Stacked 100% Bar Chart in Power BI"},"content":{"rendered":"<div>\n<p>The Power BI stacked 100% bar chart displays the metric information in percentages. Let me show you how to create a 100% stacked bar 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 ezoic-adl\"\/><\/span><\/p>\n<p>For this Power BI stacked 100% bar 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% bar chart in Power BI<\/h2>\n<p>To create a Power BI stacked 100% bar chart, first drag and drop the Sales Amount section of the fields to the region of the canvas. Automatically create a column chart, as shown below.<\/p>\n<figure class=\"wp-block-image\"><img alt='create-100-stacked-bar-chart-in-power-bi-1-7773382' width='1203' height='664' class=\"wp-image-30053\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-1-7773382.png 1203w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-1-7773382-300x166.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-1-7773382-1024x565.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-1-7773382-768x424.png 768w' data-lazy-sizes='(max-width: 1203px) 100vw, 1203px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-1-7773382.png'\/><noscript><img alt='create-100-stacked-bar-chart-in-power-bi-1-7773382' width='1203' height='664' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-1-7773382.png' class=\"wp-image-30053\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-1-7773382.png 1203w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-1-7773382-300x166.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-1-7773382-1024x565.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-1-7773382-768x424.png 768w' sizes='(max-width: 1203px) 100vw, 1203px'\/><\/noscript><\/figure>\n<p>Clicking on the 100% bar chart stacked below the <strong>Display<\/strong> section automatically converts column chart to stacked bar chart at 100%<\/p>\n<figure class=\"wp-block-image\"><img alt='create-100-stacked-bar-chart-in-power-bi-2-9175628' width='1202' height='675' class=\"wp-image-30054\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-2-9175628.png 1202w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-2-9175628-300x168.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-2-9175628-1024x575.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-2-9175628-768x431.png 768w' data-lazy-sizes='(max-width: 1202px) 100vw, 1202px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-2-9175628.png'\/><noscript><img alt='create-100-stacked-bar-chart-in-power-bi-2-9175628' width='1202' height='675' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-2-9175628.png' class=\"wp-image-30054\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-2-9175628.png 1202w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-2-9175628-300x168.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-2-9175628-1024x575.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-2-9175628-768x431.png 768w' sizes='(max-width: 1202px) 100vw, 1202px'\/><\/noscript><\/figure>\n<p>Next, let me add the name of the English country region to the Axis section to create a bar chart of the 100%. This chart shows the number of sales (in percent) by country region name in English.<\/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-bar-chart-in-power-bi-3-3747775' width='1228' height='685' class=\"wp-image-30055\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-3-3747775.png 1228w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-3-3747775-300x167.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-3-3747775-1024x571.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-3-3747775-768x428.png 768w' data-lazy-sizes='(max-width: 1228px) 100vw, 1228px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-3-3747775.png'\/><noscript><img alt='create-100-stacked-bar-chart-in-power-bi-3-3747775' width='1228' height='685' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-3-3747775.png' class=\"wp-image-30055\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-3-3747775.png 1228w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-3-3747775-300x167.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-3-3747775-1024x571.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-3-3747775-768x428.png 768w' sizes='(max-width: 1228px) 100vw, 1228px'\/><\/noscript><\/figure>\n<p>We then added the Occupancy section to the legend to make it the 100% stacked bar chart.<\/p>\n<figure class=\"wp-block-image\"><img alt='create-100-stacked-bar-chart-in-power-bi-4-6131032' width='1227' height='683' class=\"wp-image-30056\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-4-6131032.png 1227w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-4-6131032-300x167.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-4-6131032-1024x570.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-4-6131032-768x428.png 768w' data-lazy-sizes='(max-width: 1227px) 100vw, 1227px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-4-6131032.png'\/><noscript><img alt='create-100-stacked-bar-chart-in-power-bi-4-6131032' width='1227' height='683' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-4-6131032.png' class=\"wp-image-30056\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-4-6131032.png 1227w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-4-6131032-300x167.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-4-6131032-1024x570.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-4-6131032-768x428.png 768w' sizes='(max-width: 1227px) 100vw, 1227px'\/><\/noscript><\/figure>\n<p>Hover over any part of a bar that will show you the tooltip for Country Name, Customer Occupation, and Sales Amount.<\/p>\n<figure class=\"wp-block-image\"><img alt='create-100-stacked-bar-chart-in-power-bi-5-2331068' width='1228' height='683' class=\"wp-image-30057\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-5-2331068.png 1228w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-5-2331068-300x167.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-5-2331068-1024x570.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-5-2331068-768x427.png 768w' data-lazy-sizes='(max-width: 1228px) 100vw, 1228px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-5-2331068.png'\/><noscript><img alt='create-100-stacked-bar-chart-in-power-bi-5-2331068' width='1228' height='683' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-5-2331068.png' class=\"wp-image-30057\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-5-2331068.png 1228w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-5-2331068-300x167.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-5-2331068-1024x570.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-5-2331068-768x427.png 768w' sizes='(max-width: 1228px) 100vw, 1228px'\/><\/noscript><\/figure>\n<h3>Create Stacked 100% Bar Chart in Power BI Approach 2<\/h3>\n<p>First, click on the 100% bar chart stacked below the <b>Display<\/b> section. Automatically creates a 100% stacked bar chart with dummy data, as shown in the following screenshot.<\/p>\n<figure class=\"wp-block-image\"><img alt='create-100-stacked-bar-chart-in-power-bi-6-4693022' width='1219' height='667' class=\"wp-image-30058\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-6-4693022.png 1219w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-6-4693022-300x164.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-6-4693022-1024x560.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-6-4693022-768x420.png 768w' data-lazy-sizes='(max-width: 1219px) 100vw, 1219px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-6-4693022.png'\/><noscript><img alt='create-100-stacked-bar-chart-in-power-bi-6-4693022' width='1219' height='667' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-6-4693022.png' class=\"wp-image-30058\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-6-4693022.png 1219w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-6-4693022-300x164.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-6-4693022-1024x560.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-6-4693022-768x420.png 768w' sizes='(max-width: 1219px) 100vw, 1219px'\/><\/noscript><\/figure>\n<p>To add data to the stacked bar chart to the 100%, we have to add the required fields:<\/p>\n<ul>\n<li><b>Axis:<\/b> Specify the column that represents the horizontal bars.<\/li>\n<li><b>Legend:<\/b> Specify the column to split the horizontal 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 English Country Region Name field to the Axis Section.<\/p>\n<figure class=\"wp-block-image\"><img alt='create-100-stacked-bar-chart-in-power-bi-7-6447845' width='1220' height='668' class=\"wp-image-30059\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-7-6447845.png 1220w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-7-6447845-300x164.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-7-6447845-1024x561.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-7-6447845-768x421.png 768w' data-lazy-sizes='(max-width: 1220px) 100vw, 1220px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-7-6447845.png'\/><noscript><img alt='create-100-stacked-bar-chart-in-power-bi-7-6447845' width='1220' height='668' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-7-6447845.png' class=\"wp-image-30059\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-7-6447845.png 1220w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-7-6447845-300x164.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-7-6447845-1024x561.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-7-6447845-768x421.png 768w' sizes='(max-width: 1220px) 100vw, 1220px'\/><\/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-bar-chart-in-power-bi-8-5702676' width='1220' height='670' class=\"wp-image-30060\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-8-5702676.png 1220w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-8-5702676-300x165.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-8-5702676-1024x562.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-8-5702676-768x422.png 768w' data-lazy-sizes='(max-width: 1220px) 100vw, 1220px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-8-5702676.png'\/><noscript><img alt='create-100-stacked-bar-chart-in-power-bi-8-5702676' width='1220' height='670' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-8-5702676.png' class=\"wp-image-30060\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-8-5702676.png 1220w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-8-5702676-300x165.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-8-5702676-1024x562.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-8-5702676-768x422.png 768w' sizes='(max-width: 1220px) 100vw, 1220px'\/><\/noscript><\/figure>\n<p>Data labels display information about each group on a horizontal bar (country). 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 18<\/p>\n<p>You can now see a stacked 100% bar chart with percentage values<\/p>\n<figure class=\"wp-block-image\"><img alt='create-100-stacked-bar-chart-in-power-bi-9-7145811' width='1125' height='667' class=\"wp-image-30061\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-9-7145811.png 1125w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-9-7145811-300x178.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-9-7145811-1024x607.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-9-7145811-768x455.png 768w' data-lazy-sizes='(max-width: 1125px) 100vw, 1125px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-9-7145811.png'\/><noscript><img alt='create-100-stacked-bar-chart-in-power-bi-9-7145811' width='1125' height='667' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-9-7145811.png' class=\"wp-image-30061\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-9-7145811.png 1125w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-9-7145811-300x178.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-9-7145811-1024x607.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-9-7145811-768x455.png 768w' sizes='(max-width: 1125px) 100vw, 1125px'\/><\/noscript><\/figure>\n<p>Let me apply a quick format to this Power BI stacked 100% bar 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 bar chart and the stacked 100% bar chart are the same. Therefore, I suggest that you refer to the Stacked Bar Chart Format article to understand the steps required to format the stacked bar colors to the 100%.<\/p>\n<figure class=\"wp-block-image\"><img alt='create-100-stacked-bar-chart-in-power-bi-10-6117601' width='1306' height='776' class=\"wp-image-30062\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-10-6117601.png 1306w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-10-6117601-300x178.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-10-6117601-1024x608.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-10-6117601-768x456.png 768w' data-lazy-sizes='(max-width: 1306px) 100vw, 1306px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-10-6117601.png'\/><noscript><img alt='create-100-stacked-bar-chart-in-power-bi-10-6117601' width='1306' height='776' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-10-6117601.png' class=\"wp-image-30062\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-10-6117601.png 1306w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-10-6117601-300x178.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-10-6117601-1024x608.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-10-6117601-768x456.png 768w' sizes='(max-width: 1306px) 100vw, 1306px'\/><\/noscript><\/figure>\n<p>This time, we added the name of the state province to the axis and the country to the legend to get a stacked bar chart at 100%. In the following screenshot, you can see that the country name acts as the color of the bar. This is because you cannot group country names within a state (inherited state name from country).<\/p>\n<figure class=\"wp-block-image\"><img alt='create-100-stacked-bar-chart-in-power-bi-11-6125208' width='1308' height='777' class=\"wp-image-30063\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-11-6125208.png 1308w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-11-6125208-300x178.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-11-6125208-1024x608.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-11-6125208-768x456.png 768w' data-lazy-sizes='(max-width: 1308px) 100vw, 1308px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-11-6125208.png'\/><noscript><img alt='create-100-stacked-bar-chart-in-power-bi-11-6125208' width='1308' height='777' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-11-6125208.png' class=\"wp-image-30063\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-11-6125208.png 1308w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-11-6125208-300x178.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-11-6125208-1024x608.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-11-6125208-768x456.png 768w' sizes='(max-width: 1308px) 100vw, 1308px'\/><\/noscript><\/figure>\n<\/div>","protected":false},"excerpt":{"rendered":"<p>El gr\u00e1fico de barras 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 barras apiladas al 100% en Power&#8230;<\/p>","protected":false},"author":1,"featured_media":86460,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1359,1360],"tags":[],"class_list":["post-86458","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 barras 100% apiladas en Power BI - R Marketing Digital<\/title>\n<meta name=\"description\" content=\"El gr\u00e1fico de barras 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 barras\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/rmarketingdigital.com\/en\/powerbi\/crear-grafico-de-barras-100-apiladas-en-power-bi\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Crear gr\u00e1fico de barras 100% apiladas en Power BI\" \/>\n<meta property=\"og:description\" content=\"El gr\u00e1fico de barras 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 barras\" \/>\n<meta property=\"og:url\" content=\"https:\/\/rmarketingdigital.com\/en\/powerbi\/crear-grafico-de-barras-100-apiladas-en-power-bi\/\" \/>\n<meta property=\"og:site_name\" content=\"R Marketing Digital\" \/>\n<meta property=\"article:published_time\" content=\"2022-05-23T01:17:37+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-10-5727091.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1306\" \/>\n\t<meta property=\"og:image:height\" content=\"776\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"R Marketing Digital\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/crear-grafico-de-barras-100-apiladas-en-power-bi\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/crear-grafico-de-barras-100-apiladas-en-power-bi\\\/\"},\"author\":{\"name\":\"R Marketing Digital\",\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/#\\\/schema\\\/person\\\/7c0d9782b2977b840b3740f00c69a73e\"},\"headline\":\"Crear gr\u00e1fico de barras 100% apiladas en Power BI\",\"datePublished\":\"2022-05-23T01:17:37+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/crear-grafico-de-barras-100-apiladas-en-power-bi\\\/\"},\"wordCount\":698,\"image\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/crear-grafico-de-barras-100-apiladas-en-power-bi\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/rmarketingdigital.com\\\/wp-content\\\/uploads\\\/2020\\\/09\\\/Create-100-Stacked-Bar-Chart-in-Power-BI-10-5727091.png\",\"articleSection\":[\"Power BI\",\"Tutoriales PowerBI\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/crear-grafico-de-barras-100-apiladas-en-power-bi\\\/\",\"url\":\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/crear-grafico-de-barras-100-apiladas-en-power-bi\\\/\",\"name\":\"Crear gr\u00e1fico de barras 100% apiladas en Power BI - R Marketing Digital\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/crear-grafico-de-barras-100-apiladas-en-power-bi\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/crear-grafico-de-barras-100-apiladas-en-power-bi\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/rmarketingdigital.com\\\/wp-content\\\/uploads\\\/2020\\\/09\\\/Create-100-Stacked-Bar-Chart-in-Power-BI-10-5727091.png\",\"datePublished\":\"2022-05-23T01:17:37+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/#\\\/schema\\\/person\\\/7c0d9782b2977b840b3740f00c69a73e\"},\"description\":\"El gr\u00e1fico de barras 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 barras\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/crear-grafico-de-barras-100-apiladas-en-power-bi\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/crear-grafico-de-barras-100-apiladas-en-power-bi\\\/#primaryimage\",\"url\":\"https:\\\/\\\/rmarketingdigital.com\\\/wp-content\\\/uploads\\\/2020\\\/09\\\/Create-100-Stacked-Bar-Chart-in-Power-BI-10-5727091.png\",\"contentUrl\":\"https:\\\/\\\/rmarketingdigital.com\\\/wp-content\\\/uploads\\\/2020\\\/09\\\/Create-100-Stacked-Bar-Chart-in-Power-BI-10-5727091.png\",\"width\":1306,\"height\":776,\"caption\":\"create-100-stacked-bar-chart-in-power-bi-10-5727091-3915139-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":"Crear gr\u00e1fico de barras 100% apiladas en Power BI - R Marketing Digital","description":"The Power BI stacked 100% bar chart displays the metric information in percentages. Let me show you how to create a bar chart","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/rmarketingdigital.com\/en\/powerbi\/crear-grafico-de-barras-100-apiladas-en-power-bi\/","og_locale":"en_US","og_type":"article","og_title":"Crear gr\u00e1fico de barras 100% apiladas en Power BI","og_description":"El gr\u00e1fico de barras 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 barras","og_url":"https:\/\/rmarketingdigital.com\/en\/powerbi\/crear-grafico-de-barras-100-apiladas-en-power-bi\/","og_site_name":"R Marketing Digital","article_published_time":"2022-05-23T01:17:37+00:00","og_image":[{"width":1306,"height":776,"url":"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-10-5727091.png","type":"image\/png"}],"author":"R Marketing Digital","twitter_card":"summary_large_image","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/rmarketingdigital.com\/powerbi\/crear-grafico-de-barras-100-apiladas-en-power-bi\/#article","isPartOf":{"@id":"https:\/\/rmarketingdigital.com\/powerbi\/crear-grafico-de-barras-100-apiladas-en-power-bi\/"},"author":{"name":"R Marketing Digital","@id":"https:\/\/rmarketingdigital.com\/#\/schema\/person\/7c0d9782b2977b840b3740f00c69a73e"},"headline":"Crear gr\u00e1fico de barras 100% apiladas en Power BI","datePublished":"2022-05-23T01:17:37+00:00","mainEntityOfPage":{"@id":"https:\/\/rmarketingdigital.com\/powerbi\/crear-grafico-de-barras-100-apiladas-en-power-bi\/"},"wordCount":698,"image":{"@id":"https:\/\/rmarketingdigital.com\/powerbi\/crear-grafico-de-barras-100-apiladas-en-power-bi\/#primaryimage"},"thumbnailUrl":"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-10-5727091.png","articleSection":["Power BI","Tutoriales PowerBI"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/rmarketingdigital.com\/powerbi\/crear-grafico-de-barras-100-apiladas-en-power-bi\/","url":"https:\/\/rmarketingdigital.com\/powerbi\/crear-grafico-de-barras-100-apiladas-en-power-bi\/","name":"Crear gr\u00e1fico de barras 100% apiladas en Power BI - R Marketing Digital","isPartOf":{"@id":"https:\/\/rmarketingdigital.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/rmarketingdigital.com\/powerbi\/crear-grafico-de-barras-100-apiladas-en-power-bi\/#primaryimage"},"image":{"@id":"https:\/\/rmarketingdigital.com\/powerbi\/crear-grafico-de-barras-100-apiladas-en-power-bi\/#primaryimage"},"thumbnailUrl":"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-10-5727091.png","datePublished":"2022-05-23T01:17:37+00:00","author":{"@id":"https:\/\/rmarketingdigital.com\/#\/schema\/person\/7c0d9782b2977b840b3740f00c69a73e"},"description":"The Power BI stacked 100% bar chart displays the metric information in percentages. Let me show you how to create a bar chart","inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/rmarketingdigital.com\/powerbi\/crear-grafico-de-barras-100-apiladas-en-power-bi\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/rmarketingdigital.com\/powerbi\/crear-grafico-de-barras-100-apiladas-en-power-bi\/#primaryimage","url":"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-10-5727091.png","contentUrl":"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Create-100-Stacked-Bar-Chart-in-Power-BI-10-5727091.png","width":1306,"height":776,"caption":"create-100-stacked-bar-chart-in-power-bi-10-5727091-3915139-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\/86458","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=86458"}],"version-history":[{"count":0,"href":"https:\/\/rmarketingdigital.com\/en\/wp-json\/wp\/v2\/posts\/86458\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/rmarketingdigital.com\/en\/wp-json\/wp\/v2\/media\/86460"}],"wp:attachment":[{"href":"https:\/\/rmarketingdigital.com\/en\/wp-json\/wp\/v2\/media?parent=86458"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rmarketingdigital.com\/en\/wp-json\/wp\/v2\/categories?post=86458"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rmarketingdigital.com\/en\/wp-json\/wp\/v2\/tags?post=86458"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}