Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi all, I am trying to plot a cumulative value for sales over the year (by months here) (
, and I am using the stacked column chart. When I don't stack the columns, the values cumulate as it should do:
However, when I use the legend option for that, it messes up the visual:
Is there a way for me to add the parameter of the legend as a cumulative parameter together with the date?
Solved! Go to Solution.
Hi @anabianco09
You can try the following measure
Cumulative Revenue = CALCULATE(SUM('AOP 2023 - Program'[Expected Revenue (converted).amount]), FILTER(ALL('AOP 2023 - Program'), 'AOP 2023 - Program'[Estimated Ship Date] <= MAX('AOP 2023 - Program'[Estimated Ship Date])))
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @anabianco09
You can try the following measure
Cumulative Revenue = CALCULATE(SUM('AOP 2023 - Program'[Expected Revenue (converted).amount]), FILTER(ALL('AOP 2023 - Program'), 'AOP 2023 - Program'[Estimated Ship Date] <= MAX('AOP 2023 - Program'[Estimated Ship Date])))
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
It is clear to see that the legend (job stage) breaks it:
but even so, I wanted to have them cumulated ....
User | Count |
---|---|
77 | |
77 | |
68 | |
67 | |
49 |
User | Count |
---|---|
108 | |
104 | |
93 | |
83 | |
64 |