Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
lotus22
Helper III
Helper III

Overlay % bar chart inside the Total Bar Chart

Any help is appreciated

Attached is the sample data and may not match the chart below

Column B and C are in Millions

Basically the four bars in X axis are for each Supplier by Year....for example, call first one Supplier A
 
1. Supplier has four bars for years 2020, 2021, 2022, 2023 and total is the number of parts they delivered in millions
2. The percent is basically the total number of parts delivered that were bad / total parts (total bad parts/total parts)
3. The growth rate is from the Minimum year (in this case 2020) to the maximum year (2024) - showing a number of increases in volume with this supplier.
4. colors are for each Year, and also light colors are for the bad parts.

 

lotus22_1-1715949988713.png

 

SupplierQTYGood/BADYear
Supplier D932023
Supplier B222023
Supplier B302021
Supplier C1392023
Supplier D432023
Supplier D1102021
Supplier C18142023
Supplier D19112022
Supplier A1352021
Supplier D1042022
Supplier A112022
1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @lotus22 ,

After my testing, it doesn't seem to be possible to insert an additional percentage bar graph. Changing the value returned by the measure to a percentage could indirectly accomplish your goal.

The Table data is shown below:

vzhouwenmsft_0-1716370501617.png

I use the following measures to calculate the percentage of bad parts.

 

Total = SUM('Table'[Good]) + SUM('Table'[Bad])
_% = 
VAR _a = SUM('Table'[Bad])
VAR _b = DIVIDE(_a,[Total],0)
RETURN _b

 

vzhouwenmsft_1-1716370673822.png

However, since it is a stacked column chart, the corresponding area is too small due to the value being a percentage, thus not displaying the data labels.

vzhouwenmsft_2-1716370890973.png

1.Changing visual objects

vzhouwenmsft_3-1716370971889.png

2.Use the card visual object to override the corresponding value(This approach is cumbersome and requires the creation of multiple card visual objects)

vzhouwenmsft_4-1716371325745.png

 

 

View solution in original post

4 REPLIES 4
Anonymous
Not applicable

Hi @lotus22 ,

Regarding your question, are you planning to implement a similar effect in Power BI Desktop?

vzhouwenmsft_0-1716198078565.png

Perhaps you could try 'stacked column chart'.

vzhouwenmsft_1-1716198541186.png

Set the color here.

vzhouwenmsft_2-1716198737607.png

Correct me if I'm misunderstanding.

Thank you for your reply @Anonymous 

 

I need to show the good/bad as percentage instead of a number.

Anonymous
Not applicable

Hi @lotus22 ,

After my testing, it doesn't seem to be possible to insert an additional percentage bar graph. Changing the value returned by the measure to a percentage could indirectly accomplish your goal.

The Table data is shown below:

vzhouwenmsft_0-1716370501617.png

I use the following measures to calculate the percentage of bad parts.

 

Total = SUM('Table'[Good]) + SUM('Table'[Bad])
_% = 
VAR _a = SUM('Table'[Bad])
VAR _b = DIVIDE(_a,[Total],0)
RETURN _b

 

vzhouwenmsft_1-1716370673822.png

However, since it is a stacked column chart, the corresponding area is too small due to the value being a percentage, thus not displaying the data labels.

vzhouwenmsft_2-1716370890973.png

1.Changing visual objects

vzhouwenmsft_3-1716370971889.png

2.Use the card visual object to override the corresponding value(This approach is cumbersome and requires the creation of multiple card visual objects)

vzhouwenmsft_4-1716371325745.png

 

 

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors