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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
afleiderman1
Helper I
Helper I

How to add up the entire measure

Hi everyone I have a quick question.

 

I have this graph 

 

 

afleiderman1_0-1671213255803.png

I have a measure called amount which sum up a column and I place this in the y axis. and I have a column caleld department which I place in my legend. My question is I want one more line here at the very top which sum up all the my previous for example I have 62+30+15+6=113 on my left most point in the graph. So I want a line which in November begins at 113 and is based on the sum of the previous 4 lines. Not sure how to do this.

3 REPLIES 3
afleiderman1
Helper I
Helper I

I just want to see basically everything added from all my filters as a seperate line in the graph . Not sure if that makes sense. 

Showing the same data twice will create a bad user experience.  Rethink your requirement. Try a stacked line chart.

lbendlin
Super User
Super User

That's a design red flag.  What is your expected benefit from this data duplication?

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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