Forum Discussion

BoogieMan_01's avatar
BoogieMan_01
Frequent Visitor
1 year ago
Solved

Issue with stacked bar chart splitting incorrectly

Hi everyone,    I have created a survey and for a question, particpants has to rate their expereince among 4 options. Currently, this is my chart but this is extremely wrong as it's not possible fo...
Need Help
techies's avatar
techies
Icon for Super User rankSuper User
1 year ago

Hi BoogieMan_01 please try this

 

Q12 Finished Responses =
CALCULATE(
    [Q12 Responses],
    FILTER(Q12, Q12[Finished] = TRUE())
)
 
Q12 Response % by Option =
DIVIDE(
    [Q12 Finished Responses],
    CALCULATE(
        [Q12 Finished Responses],
        ALLSELECTED(Q12[Q12])
    )
)
BoogieMan_01's avatar
BoogieMan_01
Frequent Visitor
1 year ago

Hi techies ! 

Thank you for the reply but unfortunately it did not work... It's still showing the same graph