Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Experts,
We have data that shows the pupulation increase for all the cities for all quarters.
In my report i have a slicer 'City' and a line graph. The requirement is when we select a particular city from the slicer, then data only for last 5 quarters should be displayed in the Line graph.
Last 5 quarters from Current date.
Please advise how can we achieve this.
Many thanks.
Solved! Go to Solution.
Hi @Anonymous,
Based on my test, you could refer to below formula to calculate the last quarter:
Sample data:
Create below calculated column:
Last quarter = IF(YEAR('Table'[Date])<MAXX('Table',YEAR('Table'[Date])),(MAXX('Table',YEAR('Table'[Date]))-YEAR([Date]))*4+5-[Quarter],[Quarter])
You could use this new column to create a slicer to show the last 5quarter:
You could also download the pbix file to have a view.
Regards,
Daniel He
Hello, I found this solution is useful to show the last quarters. However, is there any method to update the last quarter compared to the current date? Thanks a lot!
Hi @Anonymous,
Based on my test, you could refer to below formula to calculate the last quarter:
Sample data:
Create below calculated column:
Last quarter = IF(YEAR('Table'[Date])<MAXX('Table',YEAR('Table'[Date])),(MAXX('Table',YEAR('Table'[Date]))-YEAR([Date]))*4+5-[Quarter],[Quarter])
You could use this new column to create a slicer to show the last 5quarter:
You could also download the pbix file to have a view.
Regards,
Daniel He
Hi Daniel, your solution is very useful! is there any method to update the last quarter compared to the current date? Thanks a lot!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
97 | |
80 | |
69 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |