Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowGet inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.
I am trying to build a visual based on data from SAP with actuals on posting data. I have used running total measure to display a cumulative graph over time. However, it either shows non-cumulative or cumulative but not sorted by proper month/year.
I would like the graph to display cumulative actuals over time (months and years) based on a CJI3 report from SAP.
What am i doing wrong?
See pictures attached.
Thank you kindly
Just write ALL function instead of ALLSELECTED.
Cumulative Actuals = CALCULATE( SUM('Table'[Actuals]),
FILTER( ALL('Table'[DateColumn]), 'Table'[DateColumn] <= MAX('Table'[DateColumn]) ) )
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code FABINSIDER for a $400 discount!
Check out the February 2025 Power BI update to learn about new features.
User | Count |
---|---|
21 | |
15 | |
11 | |
10 | |
10 |