100% Stacked bar chart with sum of two columns

[Anonymous]

Hi, I'm trying to figure out how to visualize two colums by placing the total value of one onto the total value of the other column as a whole. Like below: 

 When I add the sum of the columns to the visual they add both together for a total of 2000KG where I want it to show as in the above picture. Please help, thanks.

[Anonymous · Accepted solution]

Hi @Anonymous

I noticed that the visual you want is not 100% stacked bar chart, here we recommend you to use the stacked bar chart, here is my solution for you:

Here's the raw data I added

First, create new columns to add the actuals and contracted columns

total actuals = SUM('Table'[actuals])

total contracted = SUM('Table'[contracted])

Next, select stacked bar chart and check New Columns

In Format visual, enable Data Labels to display data

The final visual is as follows

If you're still having problems, provide some dummy data and the desired outcome. It is best presented in the form of a table.

Best Regards,

Nono Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[barritown · Accepted solution]

Hi,

@Anonymous,

@Anonymous has already proposed a solution, but I'll add my two cents here since I've understood the task differently - in my understanding, the second bar should be still 66,6% but captioned differently. 

I guess you need to apply custom captions here but unfortunatelly PBI doesn't allow to place them outside the bar.

First, create those captions via measures:

Caption 1 = SUM ( 'Table'[Actuals] )

Caption 2 = SUM ('Table'[Actuals] ) + SUM ('Table'[Contracted] )

And then apply via the menu @Anonymous already mentioned:

Best Regards,

Alexander

My YouTube vlog in English

My YouTube vlog in Russian

[Anonymous · Accepted solution]

Hi @Anonymous

I noticed that the visual you want is not 100% stacked bar chart, here we recommend you to use the stacked bar chart, here is my solution for you:

Here's the raw data I added

First, create new columns to add the actuals and contracted columns

total actuals = SUM('Table'[actuals])

total contracted = SUM('Table'[contracted])

Next, select stacked bar chart and check New Columns

In Format visual, enable Data Labels to display data

The final visual is as follows

If you're still having problems, provide some dummy data and the desired outcome. It is best presented in the form of a table.

Best Regards,

Nono Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.