cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
cassiehehe Regular Visitor
Regular Visitor

How to add a cumulated line char on a bar chart

The graph works fine with cumulated total value after adding on the following measures:

 

Cumulated Trade Volume =
VAR TopDate = MAX ( 'Table'[Trade Date] )
RETURN
CALCULATE(
    SUM ( 'Table'[Trade Volume] ),
    ALLSELECTED( 'Table'),
    'Table'[Trade Date] <= TopDate
)
 
 
 
ccccccccccc.PNG
 
However, with some individual security, it does work well as follows:
 
ddddddddd.PNG I am guessing it is because the volume is too small to show up. How to change the counting units? Thanks
 
 
5 REPLIES 5
cassiehehe Regular Visitor
Regular Visitor

Re: How to add a cumulated line char on a bar chart

The line chart is not right which is cumulated value. Can someone help me out? Thanks!

emmahyt Frequent Visitor
Frequent Visitor

Re: How to add a cumulated line char on a bar chart

upupup
cassiehehe Regular Visitor
Regular Visitor

Re: How to add a cumulated line char on a bar chart

Anyone can help me out?Thanks

cassiehehe Regular Visitor
Regular Visitor

Re: How to add a cumulated line char on a bar chart

upupupup

Community Support Team
Community Support Team

Re: How to add a cumulated line char on a bar chart

Hi @cassiehehe ,

You can change visual type to 'line and clustered column chart' to add cumulative measure on line fields.

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 104 members 1,589 guests
Please welcome our newest community members: