This is the second part of the video on how to create a pareto chart in Power BI. This video shows you how to handle ties in Pareto % calculation. Ties in a Pareto chart are when the same rank appears more than once. Creating a Pareto Chart is not difficult and this video will […]
SOLVED! Pareto Chart with TIES In Power BI | Step-By-Step Tutorial | Part 2 Read More »
Creating a Pareto Chart in Power BI is not difficult and this video will show you step-by-step how to create one. You can then use this technique to apply the 80/20 rule in your own use case. Power BI lets you create Pareto charts without the need for any other custom visuals. I’ll walk you
How to Make a Pareto Chart in Power BI | Step-By-Step Tutorial | Part 1 Read More »
In this video, I will show you why sometimes your DAX formulas return wrong results. I will also show you how to easily fix them in Power BI and explain what exactly causes the unexpected results in your DAX calculations or formulas. The video goes into the various DAX errors mistakes that beginner of Power
Why Do My DAX Formulas Return Wrong Results? Read More »
In this video, I will show you how to highlight the lowest and highest cumulative total sales dynamically on a chart using conditional formatting in Power BI. It is relatively easy to see a single data point on a chart, but highlighting the lowest and highest time period is a more challenging task, which can
Highlight LOWEST and HIGHEST Periods Dynamically on Power BI Chart Read More »
In this video, I will walk you through on how to effortlessly create a custom PAGE NAVIGATION PANEL in Power BI with Bookmarks & Buttons. You will also learn many visualization tips and tricks along the way. Creating a page navigation menu with a pane to navigate to different Power BI report pages is super
Power BI PAGE NAVIGATION Panel with Bookmarks & Buttons Read More »
In this video, I’m going to show you how to use the Native Power BI visuals to create progress circle and bar charts using donut and 100% stacked bar charts in Power BI Desktop. You will learn some awesome visualization tips and tricks along the way. The circle chart is also called the radial bar
HOW TO Make Progress Circle and Bar Charts With Native Power BI Visuals Read More »
Below video shows how to calculate the moving average or the rolling average and build informative rich tooltips in Power BI. When you highlight events on a line chart with time-series data, providing a moving average gives a clear indication of the trend on a chart. You will also learn some useful DAX techniques in
Part-2 How to HIGHLIGHT events, MOVING AVERAGE & build rich TOOLTIPS in Power BI Read More »
in this video, you will learn how to highlight any time bound events on a chart timeline using DAX and conditional formatting in Power BI. In addition, in this example, we will analyze and visualize how events like Covid lockdown, promotions, and campaigns impact sales performance. Once you learn these techniques , you can apply them on
Part 1 – Learn how to HIGHLIGHT events on Power BI chart TIMELINE Read More »
Setting default date filters in Power BI is a challenging task. if you need to filter to a certain date range such as Today, current month, the past 7 days, and so on. I am sharing a technique here on how to achieve it using DAX and Calculation groups. The technique shown here can be
Setting Default Dynamic Date Filters in Power BI Read More »
In this article/video, I am sharing a data visualization technique In Power BI to build an In-page navigation element using bookmarks and buttons to provide a user-friendly experience to navigate within a report page. When building reports in Power BI, it’s important to keep the layout simple and to show only the relevant visuals
How to create an In-Page Navigation with Bookmarks and Buttons in Power BI Read More »