How to select max of date in stacked bar chart

[Naveen_SV]

HI ALl,

I have requirement

1) i need to show stacked bar chart with the max of period value(Latest of the period value).

2) and when i select any of the other months in the period chart stacked bar chart should show top 5 

Stacked bar chart should show latest value clustered column should show same period from Jan till May.

when i select value from period then according to that period top 5 stacked bar chart should show.

[v-lid-msft · Accepted solution]

Hi @Naveen_SV ,

We can create a measure and use it in the stacked bar chart to meet your requirement:

MeasureQty =
IF (
    ISFILTERED ( 'Table'[Period] ) || ISFILTERED ( 'Table'[Period].[Month] ),
    VAR t =
        SUMMARIZE (
            ALLSELECTED ( 'Table' ),
            'Table'[Item],
            "IQty", SUM ( 'Table'[Qty] )
        )
    VAR r =
        RANKX ( t, [IQty], SUM ( 'Table'[Qty] ), DESC, DENSE )
    RETURN
        IF ( r <= 2, SUM ( 'Table'[Qty] ), BLANK () ),
    CALCULATE (
        SUM ( 'Table'[Qty] ),
        FILTER (
            'Table',
            'Table'[Period].[MonthNo]
                = MONTH ( CALCULATE ( MAX ( 'Table'[Period] ), ALLSELECTED ( 'Table' ) ) )
        )
    )
)

We can change the r <=5 to show the top 5 item when month selected

If it doesn't meet your requirement, Please show the exact expected result based on the Tables that you have shared.

Best regards,