Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
@Anonymous,
You can upload PBIX file to OneDrive and post shared link of it here.
Regards,
Lydia
@Anonymous,
You can send me the link through Private message.
Regards,
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |