Forum Discussion
Current Year vs Previous Year
Hello,
I am looking to create a line chart that compares the current year's customer exits to the previous year's. The default display will be the latest year's exit customers, with the previous year's exit customers shown for comparison. For example, if the latest year is 2023, the chart will display 2023 exit customers as the current year and 2022 exit customers as the previous year. The chart will be slicer-enabled so that when the user selects a specific year, the line chart will automatically update to show that year's current year and previous year exit customers. The legend should be dynamic, displaying the years selected in the chart. I hope this makes sense. Please let me know if you have any questions or need further clarification. Thank you.
7 Replies
- Ashish_Mathur
Super User
Hi,
Share some data to work with. Show the expected result in a simple Table format. Share data in a format that can be pasted in an MS Excel file. To calculate exits, should the base be the previuos month or same month last year?
- sanjeevgupta123New Member
Please see the attached file for your reference
https://drive.google.com/file/d/1km7yHZnZXXB98XBleX4sNXqR_9NszSiz/view?usp=drivesdk
- Ashish_Mathur
Super User
Hi,
Please answer the last question i asked in my previous message. Also, show the expected result for Jan and Feb current year and previous year. By current year, do you mean the Year selected in the slicer.
- Ritaf1983
Super User
Hi ayush75031 please refer to the linked guide :
https://www.youtube.com/watch?v=VLOHvQyCKWo
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
- sanjeevgupta123New Member
Thank you,
Please give another example where we show current year and previous year exit customer rather then cumulative numbers I want to show comparison
Thank un advance
- ayush75031Frequent Visitor
Hi Ashish,
Thank you so much for your prompt reply. Please see the below screenshot for your reference
By default it is giving me latest year and last year exit customer
If I select year then it shows me below resultCould you please let me know how we can achieve this
link for PBIx: https://drive.google.com/file/d/1km7yHZnZXXB98XBleX4sNXqR_9NszSiz/view?usp=drive_link- Ashish_Mathur
Super User
You have not answered the questions i has asked yesterday. How do you expect me to help you?