Ranking Categories with Power BI

Ranking Categories with Power BI

How to visualize the top n categories and others with MS Power BI. I recently started working with Power BI more constantly, and I’ve been learning a bunch of things with the tool.

I recently started working with Power BI more constantly, and I’ve been learning a bunch of things with the tool.

I thought coming from a more code-oriented perspective would make it easier for me to tackle tools such as Power BI, but change is often uncomfortable anyways.

Image for post

Illustration from DamianNiolet

If you’re used to a business-oriented solution, it’ll be a pain learning how to code and having to be responsible for almost every aspect of your visualization. And if you’re coming from code, you’ll have to get used to the limitations of your new tool, having to adapt the original idea, and creating workarounds.

In this article, I’ll share one of my recent challenges and the solutions I found for representing grouped and ranked data.

If you’re new to Power BI, I hope you’ll learn something with me, and if you’re a pro with the tool, maybe you can get some laughs at my mistakes and give me some pointers for my next projects.


The Request

The initial task sounded quite straightforward. The customer wants to see the count by category.

power-bi data-analysis business-intelligence data-visualization rankings data analysis

Bootstrap 5 Complete Course with Examples

Bootstrap 5 Tutorial - Bootstrap 5 Crash Course for Beginners

Nest.JS Tutorial for Beginners

Hello Vue 3: A First Look at Vue 3 and the Composition API

Building a simple Applications with Vue 3

Deno Crash Course: Explore Deno and Create a full REST API with Deno

How to Build a Real-time Chat App with Deno and WebSockets

Convert HTML to Markdown Online

HTML entity encoder decoder Online

Business Intelligence Visualizations with Power BI

In this article, I include an extensive guide on how to utilize Power BI, a business analytics service provided by Microsoft, to prepare our data visualization analysis. Please join me in this practical explanation!

Tableau vs Power BI: Comparing the Data Visualization Tools

In analytics, Tableau is the leading visualisation tool. Its rich analytical features and attention to data details are the reason behind its popularity. Power BI, on the other hand, is preferred by professionals who are more comfortable with...

Managing your Data with Microsoft’s Power BI

In a world where the sheer amount of data is often overwhelming, the ability to interrogate and organise data to make meaningful business decisions is more important than ever. Microsoft have created Power BI to enable every day users to use the...

Explore your JIRA Data with Power BI

JIRA Software provides bug tracking, issue tracking, and project management capabilities for teams and organizations. The JIRA content pack for Power BI helps you quickly import JIRA data so you can get an instant dashboard to analyze workloads...

Formatting Data in Power BI Desktop Visualizations

This article provides a stepwise guide on how to work with Power BI data visualization and apply various types of formatting.