Forum Discussion

lotus22's avatar
lotus22
Helper III
2 years ago
Solved

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,...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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)

     

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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.

  • lotus22's avatar
    lotus22
    Helper III
    2 years ago

    Thank you for your reply Anonymous 

     

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      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)