The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Any help is appreciated
Attached is the sample data and may not match the chart below
Column B and C are in Millions
Supplier | QTY | Good/BAD | Year |
Supplier D | 9 | 3 | 2023 |
Supplier B | 2 | 2 | 2023 |
Supplier B | 3 | 0 | 2021 |
Supplier C | 13 | 9 | 2023 |
Supplier D | 4 | 3 | 2023 |
Supplier D | 11 | 0 | 2021 |
Supplier C | 18 | 14 | 2023 |
Supplier D | 19 | 11 | 2022 |
Supplier A | 13 | 5 | 2021 |
Supplier D | 10 | 4 | 2022 |
Supplier A | 1 | 1 | 2022 |
Solved! Go to Solution.
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:
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
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.
1.Changing visual objects
2.Use the card visual object to override the corresponding value(This approach is cumbersome and requires the creation of multiple card visual objects)
Hi @lotus22 ,
Regarding your question, are you planning to implement a similar effect in Power BI Desktop?
Perhaps you could try 'stacked column chart'.
Set the color here.
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.
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:
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
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.
1.Changing visual objects
2.Use the card visual object to override the corresponding value(This approach is cumbersome and requires the creation of multiple card visual objects)