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

Total value variation column chart

Hello all ,

 

i have sample data like below  want to show total value column in graph 

 
 
 

measure : 

 

variation = sum('Master Data Base'[Value])
 
 
Master data base :
 
Reduction Buckets                               Value
 
1.overstock consumption                       4.7
2.scrap                                                    -0.6
3.supply improvements                         1.6
4.sell back oms                                       0.4
5.New materials                                     -4.6
 
Now  graph looks like 
 
THENNA_41_0-1636455373761.png

 

How to get total  Values   graph like below 

 

 

THENNA_41_1-1636455415829.png

 

thanks in advance. any option to do that ?  there is no option for data lable for total . 

 

 
 

 

 
1 ACCEPTED SOLUTION
VahidDM
Super User
Super User

Hi @THENNA_41 

 

Download this file:

https://gofile.io/d/NrNWmb

 

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

 

Appreciate your Kudos!!

View solution in original post

8 REPLIES 8
THENNA_41
Post Partisan
Post Partisan

@VahidDM  both values  come from single table  Master data base only .  Reduction Buckets ,values its two column .  

THENNA_41
Post Partisan
Post Partisan

i  have  Reduction Buckets    totaly 10 list but i am selecting only 5 values 

The number of items won't make any issue with that code.

 

Appreciate your Kudos!!

 

THENNA_41
Post Partisan
Post Partisan

@VahidDM  Each table argument of 'UNION' must have the same number of columns i am getting this warning 

Yes, The two tables must have the same number of columns.

https://docs.microsoft.com/en-us/dax/union-function-dax

 

If you have a table with many columns, summarize that.

 

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

 

Appreciate your Kudos!!

 

THENNA_41
Post Partisan
Post Partisan

@VahidDM  thank you so much 

No Worries

🙏

VahidDM
Super User
Super User

Hi @THENNA_41 

 

Download this file:

https://gofile.io/d/NrNWmb

 

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

 

Appreciate your Kudos!!

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.