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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

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