March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
I am trying to show the current and previous revenues based on user time selection in the slicer. I am wondering if you can give me feedback on this table because as I have shown it to a couple of my colleagues I needed to explain to them what it shows. any ideas on improvement on this and if you have your solution example you can share.
Solved! Go to Solution.
The best visual for that will not use the term "previous period" but will spell out the scope ( for example January 2023) so there's no ambiguity.
@stribor45
Provide clear explanation and some sample data and the expected results. When you say Previous, is it previous month/QTR/Year/Day ?
If you have a dates or calendar tabble in your model, you can use the time intelligence function in DAX to get the desiresed results. Time intelligence functions (DAX) - DAX | Microsoft Learn
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
The report has two slicers. Slicer #1 is months and slicer # 2 is years.
If user selects 2024 and January it will show the following data
Current - this would be January 2024 data
Prev - this would be the same data from last year (January 2023)
Change - variance between the two
If the user selects 2023 it will show following
Current - Jan. Feb, March etc for 2023
Prev - Jan, Feb, March etc for 2022
Change - variance between the two
"Prev" uses SAMEPERIODLASTYEAR function.
My quesrtions is more about is there a different way to present this data. If you look at my image above without me telling you what is woud you know what it is showing?
The best visual for that will not use the term "previous period" but will spell out the scope ( for example January 2023) so there's no ambiguity.
Do you mean to add another column between current and previous?
For a generic solution on "previous values" you can also consider using the OFFSET function ( with REL -1)
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
129 | |
90 | |
75 | |
58 | |
53 |
User | Count |
---|---|
200 | |
104 | |
101 | |
67 | |
55 |