Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
I have a KPI with a yearly target of 31. I would like to have the target adjust to the time period selected by the date slicer. My current measure for the target is Target=31. Any way to make the target more dynamic?
Hi @Anonymous,
Could you please offer some sample data to have a test and post your desired result if possible?
Regards,
Daniel He
Here is a screen shot of the KPI and the fields. i would like the target to change if I had filtered it by calendar month so 31 for the year and 2.6 per month.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
Check out the February 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 50 | |
| 49 | |
| 35 | |
| 15 | |
| 14 |
| User | Count |
|---|---|
| 91 | |
| 75 | |
| 41 | |
| 26 | |
| 25 |