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:
When I then refresh visuals it looks like this:
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.
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.
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:
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.