Stacked Area accumulative Chart issue

[Anonymous]

Hi

I need to create a visual of a trend aggrigating all the items ( total 3 different items)  over the quarter.

The chart should look like this:

My table looks like this :

Item Type	date
Deployed	25/1/2021
Green	29/1/2021
Red	6/2/2021
Yellow	7/2/2021
Red	9/3/2021
Green	10/4/2021

Could you please guide me how to go about it ?

Thanks in advanced !

[Icey · Accepted solution]

Hi @Anonymous ,

Please check:

1. Create a Calendar table and a Item Types table.

Calendar = CALENDAR(DATE(2021,1,1),DATE(2021,12,31))

Item Types = DISTINCT('Table'[Item Type])

2. Create relationships.

3. Create a measure and create a Area chart.

Measure =
CALCULATE (
    COUNT ( 'Table'[Item Type] ),
    FILTER (
        ALLSELECTED ( 'Table' ),
        'Table'[Item Type] = MAX ( 'Item Types'[Item Type] )
            && 'Table'[date] <= MAX ( 'Calendar'[Date] )
    )
)

Best regards

Icey

If this post helps, then consider Accepting it as the solution to help other members find it faster.