In this webinar, I showed how to find and fix DAX formulas errors in Power BI. Learn why your DAX formulas return wrong results and how to identify the problems and correct them. DAX is a powerful language that can make the tasks of data analysis and reporting in Power BI and Excel easier. However, […]
Power BI DAX Webinar | Why Do My DAX Formulas Return Wrong Results? | M365 Chicago Read More »
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 short article, I will share with you a simple technique to create a Dates or Calendar table template in Tabular Editor and add to any Power BI file using a macro.
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 »