Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Clustered Column Chart Help

    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 ...
Need Help
  • v-haibl-msft's avatar
    v-haibl-msft
    8 years ago

    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

v-haibl-msft's avatar
v-haibl-msft
Microsoft Employee
8 years ago

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