Under categories, you can enable the top/bottom N, where you have several options. So we would like to show only the most important information, so the countries with the biggest variance.
But then, at the bottom, you still have some countries that are, again, very interesting because they had a really big negative variance. Then you have a lot of countries that are more or less on the plan, so you don’t need to concern yourself with them since there was no variance. There are some countries that have contributed very positively to your results. For example, you have a lot of variables, in this case, countries. One of the best ways to do this is to use the top N feature in Zebra BI. So it is best to make sure that you present only the most important information in the tooltip. Now, it's really important that you don’t put a lot of elements in this little chart since you don't have a lot of space. So when you're designing tooltips, make sure to then switch the page view to the actual size which will give you an idea of how much real estate you actually have. The image gets really, really big because Power BI always switches the pages by default to fit the page. Then go to the page size and switch from the default to tooltip. This now means that this page can be used as a tooltip anywhere else on your dashboard and in your report. To make this a tooltip that will appear on another visual somewhere else, you need to turn on the tooltip option. When you're designing, go to the “page information”. You then put a chart onto the page and design it, and you need to make sure that the tooltip is not too big. In our case, we named the page “tooltip”. Note: This is one of our most popular Power BI dashboard tips, both with report creators and end-users.įirst of all, you need to design a separate page, you can do so by pressing the " +" icon in the bottom. Let's create tooltips that will "wow" your end-users. On a landing page, you want to keep your information short and sweet and especially focused on the most important data categories - the ones that have contributed the most to your end result. The tiles around are the context that explains this. You’re more or less on the plan in October with your revenue, it looks like 0.6%, so right on the plan. Around it, you need to provide some context in order for people to understand. You should have a key KPIs on the top left part of your dashboard. Let’s take for example one of the default Power BI dashboard layouts.įirst, it needs to have a layout that people will understand. For many of them, the experience of just consuming the dashboard can be quite overwhelming. They are not necessarily Power BI ninjas and they will not necessarily find all the little features and click on all the slicers that you've put on your dashboard.
What you have to have in mind when designing dashboards in Power BI are the end-users. Many times people try to use multiple features at once and they often fail because they just put too many things on a dashboard or just do it in a way that is not very user-friendly.
We have noted that this can be quite a difficult hurdle to get over. If you prefer to watch the video, scroll to the bottom of this tutorial, enter your details and we'll send you the webinar recording and all PBIX examples to go along with it. Note: This tutorial is based on our 1-hour webinar on the same topic. In this tutorial, our CEO, Andrej Lapajne, unveils his best tips and methods for designing your dashboards, which will serve you well into 2021 and allow you to stay ahead of your competition. With Microsoft Power BI evolving each month, it is important to stay on top of it so you can use every feature to its fullest. Welcome to our roundup of the best and most effective Power BI Dashboard tips and tricks.