Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
88 | |
82 | |
66 | |
64 | |
57 |
User | Count |
---|---|
171 | |
111 | |
109 | |
72 | |
71 |