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 date, but also show the compared count from the samePeriodlastYear.

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

3 Replies

  • 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

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

    Anonymous

     

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

     

    Best Regards,
    Herbert