Tag: Ranking in Power BI

Ranking Analysis In Power BI: Advanced Insights From Combined Data Sets

In this tutorial, I’m going to show you some advanced ranking analysis in Power BI. As an example, I’m going to use the report that I submitted for the 10th Power BI Challenge on the Enterprise DNA forum. I have discussed the other pages in this report in other tutorials. For now, I would like

Continue reading

RANKX In Power BI – Developing Custom Tiebreakers

Develop Custom Tiebreakers in RANX Power BI and DAX

I’m going to show you how to create custom tiebreakers when using RANKX in Power BI. Getting a tie in a critical portion of RANKX results is a common scenario. There are a number of tiebreakers you can use but it’s important to choose the one that makes the most sense for each situation. You

Continue reading

Dynamic Segmentation With Dynamic Parameters – Advanced Power BI & DAX Technique

Dynamic Segmentation With Dynamic Parameters - Advanced Power BI & DAX Technique

I’m going to talk about dynamic segmentation using dynamic parameters because I’ve seen members ask about it so many times on the Enterprise DNA support forum. You may watch the full video of this tutorial at the bottom of this blog. What’s challenging about this is figuring out which areas to segment first. You would

Continue reading

Custom Conditional Formatting Techniques In Power BI

There have been some relatively recent updates when it comes to creating custom conditional formatting inside your Power BI tables. For this tutorial, I want to highlight the various things you can do with this new feature. You may watch the full video of this tutorial at the bottom of this blog. The conditional formatting

Continue reading

Pareto Analysis: Who Are The Top 20% Customers

Hey everyone, have I got an interesting insight for you! In this article, I’m going to go over the Pareto analysis and help you identify your top 20% customers. You may watch the full video of this tutorial at the bottom of this blog. Not only do we want to break out the top 20%

Continue reading