cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Giant Member
Member

Sum in chart

Hello Expert,

 

How to get Sum  number in charts like highlighed in below mentioned screen. Help with the step

 

bi.png

Shree

 

1 ACCEPTED SOLUTION

Accepted Solutions
tex628 New Contributor
New Contributor

Re: Sum in chart

This will result in you 37,4 value appearing in the chart as a new column. You need to use the country column from the country table as it is the only one that has the Total column value!

/ J

View solution in original post

13 REPLIES 13
tex628 New Contributor
New Contributor

Re: Sum in chart

Change the postition option on your graph to "inside end" in the data labels options.

image.png

Giant Member
Member

Re: Sum in chart

Thanks..

This is data label. How   37.4 value we can be added in chart

 

Shree

tex628 New Contributor
New Contributor

Re: Sum in chart

Sorry i missunderstood. 37.4 can be added but its quite complicated.
What is the legend dimension that you are using?
Is everything in one table or do you have dimension tables?

Giant Member
Member

Re: Sum in chart

1)Dimension is country

2)everything is in one table

tex628 New Contributor
New Contributor

Re: Sum in chart

This would require you to change your datamodel, but what you would need is something like this:

image.png

By creating double crossfilter relationships between these three tables you can get a "Total" value in your country dimension that is mapped to all of your countries. This should give you the result you are looking for!

/ J

Giant Member
Member

Re: Sum in chart

will it populate like 37.4 (KPI)  value in chart and which column to be added like in dim and fact in your case

 

 

bi.png

tex628 New Contributor
New Contributor

Re: Sum in chart

This will result in you 37,4 value appearing in the chart as a new column. You need to use the country column from the country table as it is the only one that has the Total column value!

/ J

View solution in original post

Giant Member
Member

Re: Sum in chart

Hi,

it is showing as column in chart ..i want this kpi to be populated along with chart

 

Shree

tex628 New Contributor
New Contributor

Re: Sum in chart

You just want the number and nothing else?

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (3,827)