Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

100% Stacked Column Chart Percentage

Hello Community,   Under 100% stacked column chart, can I have the chart considering negative value and show the % (yellow cells) as below?   It looks like the chart will convert negative n...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous ,

     

    Sorry for my late reply.

    Here's my solution.

     

    1.Unpivot the table in Power Query

     

    2.Because there can only be one field in the axis, we have to merge the two columns to create the following calculated column.

    P&U = [Period]&"-"&[Unit]

     

    3.Create the following measure

    Measure = DIVIDE(SUM('Table'[Value]),CALCULATE(SUM('Table'[Value]),FILTER(ALLEXCEPT('Table','Table'[P&U]),[Attribute]="Sales")))

     

    4.The result circled in the red box is the result you want, you can check it.

     

    More details in the attachment.

     

     

    Best Regards,

    Stephen Tao

     

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

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous ,

 

Sorry for my late reply.

Here's my solution.

 

1.Unpivot the table in Power Query

 

2.Because there can only be one field in the axis, we have to merge the two columns to create the following calculated column.

P&U = [Period]&"-"&[Unit]

 

3.Create the following measure

Measure = DIVIDE(SUM('Table'[Value]),CALCULATE(SUM('Table'[Value]),FILTER(ALLEXCEPT('Table','Table'[P&U]),[Attribute]="Sales")))

 

4.The result circled in the red box is the result you want, you can check it.

 

More details in the attachment.

 

 

Best Regards,

Stephen Tao

 

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