Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Stacked Area accumulative Chart issue

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 Typedate
Deployed25/1/2021
Green29/1/2021
Red6/2/2021
Yellow7/2/2021
Red9/3/2021
Green10/4/2021
 

 

Could you please guide me how to go about it ?

 

Thanks in advanced !

 

 

 

 

Need Help
  • Icey's avatar
    Icey
    5 years ago

    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.

1 Reply

  • Icey's avatar
    Icey
    Icon for Community Support rankCommunity Support
    5 years ago

    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.