Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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)
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.