Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredJoin 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.
I have a dashboard with a table that has a lot of fields and I use a slicer to filter the data on it that has 3 values (strings).
In the online service I get the visual exceded error in one of the value that I filter (the other two work fine).
The table that is used in the visual has the 713 rows.
If I remove "just" ine field it works perfectly.
The field I remove is buit in this manner:
Actual Planned Code Ready = CALCULATE (
VALUES ( 'public Planned Code Ready'[Planned Code Ready] );
TOPN (
1;
FILTER('public Planned Code Ready';'public Planned Code Ready'[issueid] = 'public jiraissue (2)'[id])
;
'public Planned Code Ready'[created]; DESC
)
) The Planned Code Ready has the following info:
What can I do to improve the performance on this formula? How can I lower the memory consumption and how to debug it?
Thanks
@Anonymous,
Is there any possibility that you can share me the PBIX file so that I can reproduce?
Regards,
Lydia
@AnonymousHow can I do that?
Thanks
@Anonymous,
You can upload PBIX file to OneDrive and post shared link of it here.
Regards,
Lydia
Thanks @Anonymous, can I send you the link via MP?
@Anonymous,
You can send me the link through Private message.
Regards,
@AnonymousDone.
Thanks
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 76 | |
| 37 | |
| 31 | |
| 27 | |
| 27 |