Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I am trying to create a stacked graph of a running total, but I am having great problems.
What i am trying to get is a graph like this:
but i am getting this:
I have a sample PBIX file here:
Grateful if someone can help me please
Solved! Go to Solution.
Hi @timknox ,
Please try this:
Create a new date table:
Date = CALENDARAUTO()
Create a measure:
Running Total =
CALCULATE(
SUM(Sheet1[Value]),FILTER(ALL('Date'),'Date'[Date]<=MAX('Date'[Date])))
@timknox , try a measure like
CALCULATE(
SUM(Sheet1[Value]),FILTER(ALL(Sheet1),Sheet1[Date]<=MAX(Sheet1[Date])))
In case you want all only date. Move that to a separate table or use date table
CALCULATE(
SUM(Sheet1[Value]),FILTER(ALL(DAte),DAte[Date]<=MAX(DAte[Date])))
Hi @timknox ,
Please try this:
Create a new date table:
Date = CALENDARAUTO()
Create a measure:
Running Total =
CALCULATE(
SUM(Sheet1[Value]),FILTER(ALL('Date'),'Date'[Date]<=MAX('Date'[Date])))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
97 | |
80 | |
66 | |
62 |
User | Count |
---|---|
145 | |
113 | |
105 | |
85 | |
65 |