Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
User | Count |
---|---|
140 | |
113 | |
104 | |
76 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |