Multiple answers and using other

[Hjameelaq]

Hello all,

I have a multiple answer question and I want to make a bar visual which is something I know how to do. What I want is to show only options that have 3% higher and show other option instead of these options that are below 3% and show a small hint underneath thus bar saying other options include 1, 3 blah blah... can you please help!

Regards, Hanna

[Hjameelaq]

How do we calculate the sum of all values for a column to be able to calcuate the % for each ? 

[FreemanZ · Accepted solution]

hi @Hjameelaq ,

try to write a calculated column like:

Column =

DIVIDE(

    data[value],

    SUM(data[value])

)

[Hjameelaq]

I will give this a try, how can we show these options on table like saying 

Others is blah blah blah...

[FreemanZ]

hi @Hjameelaq ,

supposing you have two columns: answer and percentage, try to plot the barchart with two calculated columns:

answer2 =

IF([percentage]>=0.03, [answer], "Others")

Percentage2 =

IF(

    [answer]=[answer2], 

    [percentage], 

    SUMX(

        FILTER(data, data[answer2]="Others"),

        data(percentage)

    )

)