Tag: Top and Bottom Results

Comparison Of Values Between Top N And Average

Comparison Of Values Between Top N And Average

In this tutorial, you’ll learn about the comparison of values between Top N and Average Of Others in Power BI. This analysis technique helps add directionality to your solution by seeing how much the Top N and Bottom N customers are above the average of the remaining customers. You can watch the full video of this tutorial at the

Continue reading

Show Changes Over Time In Power BI Reports

In this Power BI Showcase, we’re going to focus on time intelligence in Power BI to showcase how our business metric changes over time. We have a reseller of a product that’s being sold throughout the East Coast of Australia. We want to analyze all their key metrics which includes Sale and Profits among other

Continue reading

When To Use TOPN In Power BI – A DAX Formula Review

This tutorial will review how to use TOPN as a virtual ranking function to generate interesting insights based on ranking logic in Power BI. You may watch the full video of this tutorial at the bottom of this blog. Using TOPN as a virtual ranking function allows you to dynamically produce the top and bottom

Continue reading

Show Top Or Bottom Results Using Ranking In Power BI

In this tutorial, we are going to dive into how to utilize ranking techniques effectively in Power BI. You may watch the full video of this tutorial at the bottom of this blog. Sometimes you don’t want to show all the results from your data in your visualization. Sometimes you only want to see the

Continue reading

Isolating The Top Or Bottom Outcomes Using RANKX In Power BI

Today we are going to focus on a technique used in the ‘Time Intelligence’ demo in the ‘Scenarios’ section of the Enterprise DNA showcase. I’ll show you how you can use RANKX in Power BI to get your top or bottom results. Being able to show dynamically the top or bottom outcomes of any calculations

Continue reading