Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

How to display total a Stacked Column Chart

I have  database table like master .  In the database i have two column   Reduction buckets   and value . table value looks like below         Reduction buckets                                   ...
Help appreciated
Help me
Help Requested
Help required
  • v-robertq-msft's avatar
    v-robertq-msft
    4 years ago

    Hi, Anonymous 

    According to your description, I can roughly understand your requirement, I think you can try to create a calculated table like this and place it into the waterfall chart to achieve your requirement

    New table =

var _total=ROW("Reduction buckets","Total","Value",SUMX(ALL('Table'),[Value]))

return

UNION('Table',_total)

    Then you can get thet able like this:

     

    Then you can get the chart like this:

     

    You can download my test pbix file below

    Thank you very much!

     

    Best Regards,

    Community Support Team _Robert Qin

    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
4 years ago

VahidDM   i am getting below warning trying to apply above measure 

 

 

  • VahidDM's avatar
    VahidDM
    Icon for Super User rankSuper User
    4 years ago

    Hi Anonymous 

     

    Your tables in UNION must have same columns, and it seams your Master Data Base has more that 2 columns.

    Please try this measure:

    Table 2 =
UNION(
    SUMMARIZE( Table, 'Table'[Reduction buckets], 'Table'[Value] ),
    ROW(
        "Reduction buckets", "total varaition",
        "Value", CALCULATE( SUM( 'Table'[Value] ), ALL( 'Table' ) )
    )
)

     

    If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
    Appreciate your Kudos!!
    LinkedIn:     www.linkedin.com/in/vahid-dm/