Showing percent of total in stacked column chart instead of count

[mickyg7]

Hi!

New to power bi - I'm wanting to edit the stacked column chart pictured below to do as title says. 

For example, the column 3051-3700m is labeled with 27 for Drilling & MIR and 185 for Down. These numbers are calculated measures of number of records for records of these statuses (Drilling & MIR or Down). Instead, I'd like them to be labeled with the perent of total.. so 13% for Drilling & MIR (27/(27+185)) and 87% for Down (185/(27+185)).

Thanks!

[lucacebraak]

@v-haibl-msft @mickyg7 @andyspa @PedroSimao00 

Is it also posible to add the procent and the exact value. 

I would like to add the percent of the total and the values that are already in the graphic

kind regards Luca

[v-haibl-msft · Accepted solution]

@mickyg7

In this scenario, you can create another measure to show the percent of total. I assume you have a dataset as below. You can use following formula to create a new measure (Please modify the table and column name according to your actual dataset).

Perent of Total = 
DIVIDE (
    [Total_Amount],
    CALCULATE ( SUM ( Table1[Amount] ), ALLEXCEPT ( Table1, Table1[Range] ) )
)

Best Regards,
Herbert

[G-newbie]

You Can use 100% chart top right. 

[SolomonAya]

In the divide function, how is [Total_amount] the numerator. The numerator for the percentage should be the individual values 

[lera]

Hi, 

What is supposed to go in "[range]" part of this formula?

ALLEXCEPT ( Table1, Table1[Range] )  

[andyspa]

Why did you create the formula with "ALLEXCEPT"?

[PedroSimao00]

Thanks @v-haibl-msft, I have one question, what is the difference between this solution and the 100% stacked  column?

[Beckham]

The way I have done this is to create new measures that do the divide separately, and gets the % you are looking for, and then add them as a tooltip.