Dear All,
I have below requirement to compare 22 KPI's for different selected time periods. Each KPI have to show its Current year value, Previous year value, Change and Change %.
I think writing measures for 22 KPIs with respective 4 values 22*4= 88 * 6 (different time periods) = 500+ measures will impact the reprot performance.
I would request you to help me on implementing the above requirement in a better way to avoid performance issue.
Thanks & Regards,
Rajeev
Helpful resources
Power BI Dataviz World Championships
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Power BI Monthly Update - December 2025
Check out the December 2025 Power BI Holiday Recap!
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
| User | Count |
|---|---|
| 31 | |
| 28 | |
| 19 | |
| 11 | |
| 10 |
