Tag: RANKX Function

Solve A Data Analytics Challenge W/Power BI Accelerator

Solve A Data Analytics Challenge W/Power BI Accelerator

For this post, I’ll walk you through a real-life scenario where you might find yourself in a similar situation where you’re asked for something by a stakeholder and you need to create a report quickly based on what they are asking for. This is exactly what the Power BI Accelerator data analytics challenge is all

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

Ranking Visualization In Power BI – Dynamic Visual

In this blog post, I want to teach you how to show your customers moving through groups over time in a dynamic way. You can do this ranking visualization in Power BI using a unique slicer. You may watch the full video of this tutorial at the bottom of this blog. When I click This

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

Advanced DAX Functions: Calculating Profit Contribution

In this blog, I’ll be discussing some more advanced DAX functions to demonstrate what’s possible in Power BI. You may watch the full video of this tutorial at the bottom of this blog. This tutorial will teach you how to visualize the profit contribution of different client tiers using advanced DAX functions. Calculating Total Profits

Continue reading