Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

Reply
Anonymous
Not applicable

Visual not working when I had one field due to Visual exceed error (powerBi Online)

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:

image.png

 

What can I do to improve the performance on this formula? How can I lower the memory consumption and how to debug it?

 

Thanks

6 REPLIES 6
Anonymous
Not applicable

@Anonymous,

Is there any possibility that you can share me the PBIX file so that I can reproduce?

Regards,
Lydia

Anonymous
Not applicable

@AnonymousHow can I do that?

 

Thanks

Anonymous
Not applicable

@Anonymous,

You can upload PBIX file to OneDrive and post shared link of it here.

Regards,
Lydia

Anonymous
Not applicable

Thanks @Anonymous, can I send you the link via MP?

Anonymous
Not applicable

@Anonymous,

You can send me the link through Private message.

Regards,

Anonymous
Not applicable

@AnonymousDone.

 

Thanks

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

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.