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

Get inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.

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
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!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

Top Kudoed Authors