Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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
@Anonymous
Please let me know if you still have problem on it.
Best Regards,
Herbert
@Anonymous
Does above solution help?
Best Regards,
Herbert
@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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |