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 :     ...
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.

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.