How can I create this type of chart?

[Americo]

Hi,

I got  a excel file that contains a table with some columns that looks like this:

Kod is Code, försäjlning is sells and vinst is profit.

The type of char that I need to create is like this:

As you see from the image, the profit of each seller is piled in a column and the other one shows the total profit. 

I've been looking in PowerBi for a template but I can't find any.

How can I a create this kind of chart?

Best regards

Americo Perez 

[McCow · Accepted solution]

Hi @Americo,

another simplest way is to create a new table "Total" and then append SUM of two table together with UNION DAX-function.
Then create a visual on a base on this joined table.

Best regs

[anandav · Accepted solution]

@Americo,

You may already know this but only available visual to 'somewhat' close to your requirement is the Line and Stacked Column chart.

The total profit will be shown as a line (not as your requirement for a column).

[McCow · Accepted solution]

Hi @Americo,

another simplest way is to create a new table "Total" and then append SUM of two table together with UNION DAX-function.
Then create a visual on a base on this joined table.

Best regs

[mussol_]

Hola Americo,

Does it has any sense?

If so, you can create two graphics, one stacked and the other one with the total.

I hope it helps you.

Josep.