Performance issues with my small multiple Deneb chart using facet layer

Hello @Greg,

Compliments for great course and great chart examples. I’ve learned a lot too!

I hope @jsodhi won’t mind me using his thread to ask another question regarding performance. I ran into serious performance issues with my small multiple Deneb chart, using facet layer. I’ve checked performance analyzer on my visual on first page load:

deneb0

When I then refresh visuals it looks like this:

deneb

So DAX isn’t a huge issue, but mysterious “Other” is freezing me down. Any ideas on what that might be? Something cache’able that loads faster after refreshing?

It’s not waiting for other visuals since everything else loads below 3s.

Hi @Ozzy. As a best practice, please start each new question in a new thread (link to an existing thread if it helps describe your issue).

The “Other” you see in performance analyzer is a characteristic of all Power BI pages and is not related to Deneb at all. AFAIK there’s no insight into what contributes to the “Other” number, and the only way I’ve heard to reduce it is to reduce the number of visuals on the page; whenever I see an “Other” number I don’t like, I move some of the visuals onto a new page.

@EnterpriseDNA, please move this first post by @Ozzy in this thread and this response into a new thread.

Greg

2 Likes

Hi @Ozzy,

Thank you for your participation in our forum. We noticed that you posted a question on an existing thread. However, to ensure that you receive the best possible assistance and your question is visible to other members and experts, we have created this new thread for your question.

Posting a question on an existing thread is not appropriate and may harm the original poster. Additionally, your question may not be visible to other members and experts, which could prevent you from receiving the best possible solution.

We encourage you to ask your question on the new thread, where our members and experts can provide more accurate and targeted solutions. When creating a new post, please provide as much detail as possible like:

  • A clear explanation of the problem you are experiencing
  • A mockup of the results you want to achieve
  • Your current work-in-progress PBIX file
  • Your underlying data file (to allow us to go into Power Query if necessary to transform your data and/or data model – often DAX questions really end up being data modeling solutions)

This will help our members and experts understand your question and provide more effective solutions.

Thank you for your understanding, and we look forward to helping you with your question.

Best regards,

I’ve tried doing so, but unfortunately it doesn’t help. Here’s my performance analyzer once I’ve moved Deneb visual + simple slicer to a new page:

deneb1

What’s weird is that other varies from 700 to 2500 on different attempts (when loading a page), but when refreshing visuals it’s always below 400, as if it had to do with caching? I have never experienced it with native visuals.

Bumping this post for more visibility from our experts and users.

Hello @Ozzy

We notice that no response was received from you on the post above.

Due to your inactivity, we’ll be tagging this post as Solved.

Please add your masked demo pbix file and other supporting links and details, and create a new thread.

Thank you!