Clustered Column Chart Help

[Anonymous]

How do I get the column chart to show the Same period last year values? It currently only shows the value from the selected date range. 

I want it to have the ability to be filtered by the date, but also show the compared count from the samePeriodlastYear.

[v-haibl-msft]

@Anonymous

Please let me know if you still have problem on it.

Best Regards,
Herbert

[v-haibl-msft]

@Anonymous

Does above solution help?

Best Regards,
Herbert

[v-haibl-msft · Accepted solution]

@Anonymous

I'm not very clear about your table structure and visuals used. I'd like to give a simple sample and you can adjust the DAX formula according to your tables and columns.

Please refer to the attached PBIX file, there are three columns (Date, Sales, Store) in Table1 and I create a Calendar table to make relationship between them. In such way, we can show the values for selected period. With following measure, we can show the same period last year values.

LY = 
CALCULATE (
    SUM ( Table1[Sales] ),
    SAMEPERIODLASTYEAR ( 'Calendar'[Date] ),
    VALUES ( Table1[Store] )
)

Best Regards,
Herbert