Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
THENNA_41
Post Partisan
Post Partisan

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                                     Value

 Overstock consumption                              2.80

 New Materials                                             (2.18)

 Scrap                                                           0.40

 supply Improvement                                   0.76

Sell back To OEM                                          0.15

 

 

i making this table in to graph 

 

THENNA_41_0-1636611452831.png

 

but how i will add total varaition of all total grpah like below images 

 

THENNA_41_1-1636611500840.png

 

 

1 ACCEPTED SOLUTION
v-robertq-msft
Community Support
Community Support

Hi, @THENNA_41 

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:

vrobertqmsft_0-1636969613518.png

 

Then you can get the chart like this:

vrobertqmsft_1-1636969613527.png

 

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.

View solution in original post

6 REPLIES 6
v-robertq-msft
Community Support
Community Support

Hi, @THENNA_41 

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:

vrobertqmsft_0-1636969613518.png

 

Then you can get the chart like this:

vrobertqmsft_1-1636969613527.png

 

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.

THENNA_41
Post Partisan
Post Partisan

@VahidDM   i am getting below warning trying to apply above measure 

 

THENNA_41_0-1636807916985.png

 

Hi @THENNA_41 

 

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/

 

 

THENNA_41
Post Partisan
Post Partisan

@VahidDM  let me check  .thank you so much 

Hi, 

Have you followed the DAX formula posted by VahidDM to find the solution to your problem?

If so, would you like to mark his reply as a solution so that others can learn from it too?

 

Thanks in advance!

How to Get Your Question Answered Quickly 

 

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.

VahidDM
Super User
Super User

Hi @THENNA_41 

 

Create a new table with this code:

Table 2 = union('Table',row("Reduction buckets","total varaition","Value",CALCULATE(sum('Table'[Value]),all('Table'))))

 

then use that to create a chart:

 

VahidDM_0-1636620753741.png

 

 

 

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/

 

 

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.

Top Solution Authors