Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have 2 columns for investment data, amount invested & a date. I would like a line chart that grows along with the dates instead of plotting them down based upon their value - similar to how Robinhood or any stock app shows their line graphs
right now it looks like this
I would want the line to cumalitively grow larger based upon the total at that correlated date - any idea on how to achieve this?
Solved! Go to Solution.
Hi, @simpleere
I simulated some data hoping to restore your problem.
Cumulative =
CALCULATE (
SUM ( 'Table'[Investment] ),
FILTER ( 'Table', [Year] <= EARLIER ( 'Table'[Year] ) )
)
Is the picture on the right the result you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @simpleere
I simulated some data hoping to restore your problem.
Cumulative =
CALCULATE (
SUM ( 'Table'[Investment] ),
FILTER ( 'Table', [Year] <= EARLIER ( 'Table'[Year] ) )
)
Is the picture on the right the result you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
are you referring to the candlestick visual?
https://www.sqlshack.com/candlestick-chart-for-stock-data-analysis-in-power-bi-desktop/
Proud to be a Super User!
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |