Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
I'm trying to display my data in such a way, using date hierarchy, where it compares it with the same period prior year.
My data is structured in such that each row counts as 1, so to calculate the number of sales for any given period it is SUM([sale]). The data basically has a sale column that contains a 1, and a date column that contains the date of the sale.
I'm trying to compare with the same period for the prior period, such that when you view 2017, it is only showing 2016 up until today, when you click on the year and drills down into the quarter view, you only see all quarters up until today, and same for the month view.
Is this possible?
You may select the third icon "Expand all down one level in the hierarchy" in the top left corner of the visualization.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
143 | |
85 | |
66 | |
51 | |
45 |
User | Count |
---|---|
216 | |
89 | |
82 | |
66 | |
57 |