Tag: Ranking in Power BI

Power BI Rank and Custom Grouping

Power BI Rank and Custom Grouping - Enterprise DNA

As data analysts, we are often required to group and rank values from a data set in order to generate trends and insights. However, not everyone knows how to do these tasks the easy way using Power BI. In today’s blog, we will examine a scenario that requires Power BI rank and custom grouping functions

Continue reading

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