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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
CamillaDiPassio
Frequent Visitor

Progressive substraction in chart

Hello everyone, 

I have a problem with the creation of a chart.

The data I have are as follows:

- Part number = a set of unique code

- Created Date= date of creation of the code

- Modified Date = date of modified of the code 

- Outcome= the code is active or not (True/False)

 

I have to create a waterfall chart where I have by month the active codes minus the subtraction of those no longer active in that month (using the modified date). 

 

I got the following chart using these formulas:

controllo = if(AND(Registry[ToControl]=false, Registry[Created].[Date]<>Registry[Modified]),1,0)    --> creation of a new column with a binary output

Quanti meno = -(DISTINCTCOUNT(Registry[PartNumber])-sum(Registry[controllo]))  --> creation of a measure by month

 

CamillaDiPassio_0-1658410647033.png

 

But in this chart I can't insert the progressive substraction, so I would to see by month the earlier number of code minus the code that are no longer active. Any suggestion?

Thank you!

 

4 REPLIES 4
CamillaDiPassio
Frequent Visitor

Hi, thank you it works!!

CamillaDiPassio
Frequent Visitor

Hi,

I insert an example of data.

 

CreatedPartNumberOutcomeModified
28/03/2022 10:45A1801TRUE29/03/2022 05:57
28/03/2022 10:45A1802TRUE29/03/2022 05:58
28/03/2022 10:45A1803TRUE29/03/2022 06:04
28/03/2022 11:36A1804TRUE29/03/2022 06:23
28/03/2022 11:38A1810TRUE29/03/2022 06:22
28/03/2022 11:38A1811TRUE29/03/2022 06:22
28/03/2022 11:38A1812TRUE29/03/2022 06:22
28/03/2022 11:38A1813TRUE29/03/2022 06:22
28/03/2022 14:23A1814FALSE28/03/2022 14:23
28/03/2022 14:24A1815FALSE28/03/2022 14:24
28/03/2022 10:38A1816FALSE08/07/2022 07:57
28/03/2022 10:38A1817FALSE08/07/2022 07:57
28/03/2022 10:38A1818FALSE08/07/2022 07:57
28/03/2022 10:39A1819FALSE08/07/2022 07:57
28/03/2022 10:39A1820FALSE07/07/2022 09:48
28/03/2022 10:39A1821FALSE07/07/2022 09:48
28/03/2022 10:44A1822FALSE27/05/2022 08:18
28/03/2022 11:37A1823FALSE08/07/2022 07:50
28/03/2022 11:38A1824FALSE08/07/2022 07:50
28/03/2022 11:39A1825FALSE08/07/2022 07:50
28/03/2022 10:34A1842TRUE28/03/2022 10:34
28/03/2022 10:34A1843TRUE28/03/2022 10:34
28/03/2022 10:34A1844TRUE28/03/2022 10:34
28/03/2022 10:34A1845TRUE28/03/2022 10:34
28/03/2022 10:34A1846TRUE28/03/2022 10:34
28/03/2022 10:34A1847TRUE28/03/2022 10:34
28/03/2022 10:35A1848TRUE28/03/2022 10:35
28/03/2022 10:35A1849TRUE28/03/2022 10:35
28/03/2022 11:42A1850TRUE28/03/2022 11:42
28/03/2022 11:43A1851TRUE28/03/2022 11:43
28/03/2022 14:34A1852FALSE28/03/2022 14:34
28/03/2022 14:34A1853FALSE28/03/2022 14:34
28/03/2022 14:34A1854FALSE28/03/2022 14:34

Please indicate the expected outcome. Is this it?

lbendlin_0-1658856335795.png

 


Also note that the seed value (the starting value) is in the same month as some of the reductions - that cannot be shown in the waterfall chart unless you go down to day level.

lbendlin
Super User
Super User

Please provide sanitized sample data that fully covers your issue. I cannot help you without usable sample data.
Please paste the data into a table in your post or use one of the file services like OneDrive or Google Drive. I cannot use screenshots of your source data.
Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors