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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

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 not 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? I am not quite sure how to correct that. Can anyone help me with that? Thanks!
 
 
Raw data in table is something like:
 
Trade volume    Trade Date
232324.23         2015/01/02
213134.22         2015/01/03
231444.33         2015/01/04 
3 REPLIES 3
jdbuchanan71
Super User
Super User

With the chart selected, under formatting - Y Axis, if you tun off 'Show secondary' is that how you want it to look?

Anonymous
Not applicable

The line chart for second graph does not run well.(There are missing values except the first point.) 

Hi @Anonymous ,

By my tests, I cannot reproduce your issue.

Capture.PNG

What do you mean "with some individual security"?

If it is convenient, could you share a dummy pbix file which can reproduce the issue, so that we can help further investigate on it? You can upload it to OneDrive and post the link here. Do mask sensitive data before uploading.

Best  Regards, 

Cherry

 

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

Helpful resources

Announcements
PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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