topic Re: Progressive substraction in chart in Custom Visuals Development Discussion

Progressive substraction in chart

CamillaDiPassio — Thu, 21 Jul 2022 13:43:22 GMT

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

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!

Re: Progressive substraction in chart

lbendlin — Sat, 23 Jul 2022 16:00:54 GMT

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

Re: Progressive substraction in chart

CamillaDiPassio — Tue, 26 Jul 2022 14:32:00 GMT

Hi,

I insert an example of data.

Created	PartNumber	Outcome	Modified
28/03/2022 10:45	A1801	TRUE	29/03/2022 05:57
28/03/2022 10:45	A1802	TRUE	29/03/2022 05:58
28/03/2022 10:45	A1803	TRUE	29/03/2022 06:04
28/03/2022 11:36	A1804	TRUE	29/03/2022 06:23
28/03/2022 11:38	A1810	TRUE	29/03/2022 06:22
28/03/2022 11:38	A1811	TRUE	29/03/2022 06:22
28/03/2022 11:38	A1812	TRUE	29/03/2022 06:22
28/03/2022 11:38	A1813	TRUE	29/03/2022 06:22
28/03/2022 14:23	A1814	FALSE	28/03/2022 14:23
28/03/2022 14:24	A1815	FALSE	28/03/2022 14:24
28/03/2022 10:38	A1816	FALSE	08/07/2022 07:57
28/03/2022 10:38	A1817	FALSE	08/07/2022 07:57
28/03/2022 10:38	A1818	FALSE	08/07/2022 07:57
28/03/2022 10:39	A1819	FALSE	08/07/2022 07:57
28/03/2022 10:39	A1820	FALSE	07/07/2022 09:48
28/03/2022 10:39	A1821	FALSE	07/07/2022 09:48
28/03/2022 10:44	A1822	FALSE	27/05/2022 08:18
28/03/2022 11:37	A1823	FALSE	08/07/2022 07:50
28/03/2022 11:38	A1824	FALSE	08/07/2022 07:50
28/03/2022 11:39	A1825	FALSE	08/07/2022 07:50
28/03/2022 10:34	A1842	TRUE	28/03/2022 10:34
28/03/2022 10:34	A1843	TRUE	28/03/2022 10:34
28/03/2022 10:34	A1844	TRUE	28/03/2022 10:34
28/03/2022 10:34	A1845	TRUE	28/03/2022 10:34
28/03/2022 10:34	A1846	TRUE	28/03/2022 10:34
28/03/2022 10:34	A1847	TRUE	28/03/2022 10:34
28/03/2022 10:35	A1848	TRUE	28/03/2022 10:35
28/03/2022 10:35	A1849	TRUE	28/03/2022 10:35
28/03/2022 11:42	A1850	TRUE	28/03/2022 11:42
28/03/2022 11:43	A1851	TRUE	28/03/2022 11:43
28/03/2022 14:34	A1852	FALSE	28/03/2022 14:34
28/03/2022 14:34	A1853	FALSE	28/03/2022 14:34
28/03/2022 14:34	A1854	FALSE	28/03/2022 14:34

Re: Progressive substraction in chart

lbendlin — Tue, 26 Jul 2022 17:25:46 GMT

Please indicate the expected outcome. Is this it?

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.

Re: Progressive substraction in chart

CamillaDiPassio — Thu, 25 Aug 2022 10:27:11 GMT

Hi, thank you it works!!