How to make a Stacked bar chart in Power bi

This recipe helps you make a Stacked bar chart in Power bi

Recipe Objective - How to make a Stacked bar chart in Power Bi

Step 1 - Definition of Stacked bar chart

It is a chart which is extending the normal or standard bar chart from looking at the numeric values across the one categorical variable to two categorical variables. In this each bar is divided into various number of bars which are stacked end to end. Each one corresponding to a level of the second categorical variable.

Step 2 - Dataset Explanation

We are going to use Eurovision 1998 to 2012 data which is a Singing competition dataset in which there are various column but we are going to discuss about required one. Country - This column consist of various countries which have taken part in this competition. Region - This column tells about various regions. Artist - This column is about the name of the artist Song - This column is about the name of the song Artist gender - Male or female artist Group.Solo - Whether the artist have taken part as a group or as a solo Points - How points have been scored by the artist Is.Final - "1" the artist has been reached in finals and "0" the artist is not reached into finals. Semi.Final - Whether the artist reached into semi finals or not

Step 3 - What output we are expecting?

We want see the number of countries reached into finals

Step 4 - Drag and Drop columns

Drag the "Country" column from the Fields pane and drop it onto the task window then do the same thing with "Is.Final" column

Step 5 - Make Stacked bar chart

Then go to the visualization pane and select a Stacked bar chart from there and the default chart will get converted to stacked bar chart.

What Users are saying..

profile image

Jingwei Li

Graduate Research assistance at Stony Brook University
linkedin profile url

ProjectPro is an awesome platform that helps me learn much hands-on industrial experience with a step-by-step walkthrough of projects. There are two primary paths to learn: Data Science and Big Data.... Read More

Relevant Projects

Create Your First Chatbot with RASA NLU Model and Python
Learn the basic aspects of chatbot development and open source conversational AI RASA to create a simple AI powered chatbot on your own.

Insurance Pricing Forecast Using XGBoost Regressor
In this project, we are going to talk about insurance forecast by using linear and xgboost regression techniques.

Recommender System Machine Learning Project for Beginners-2
Recommender System Machine Learning Project for Beginners Part 2- Learn how to build a recommender system for market basket analysis using association rule mining.

Build a Collaborative Filtering Recommender System in Python
Use the Amazon Reviews/Ratings dataset of 2 Million records to build a recommender system using memory-based collaborative filtering in Python.

Build OCR from Scratch Python using YOLO and Tesseract
In this deep learning project, you will learn how to build your custom OCR (optical character recognition) from scratch by using Google Tesseract and YOLO to read the text from any images.

Build a Logistic Regression Model in Python from Scratch
Regression project to implement logistic regression in python from scratch on streaming app data.

AWS MLOps Project to Deploy Multiple Linear Regression Model
Build and Deploy a Multiple Linear Regression Model in Python on AWS

Build a Face Recognition System in Python using FaceNet
In this deep learning project, you will build your own face recognition system in Python using OpenCV and FaceNet by extracting features from an image of a person's face.

Topic modelling using Kmeans clustering to group customer reviews
In this Kmeans clustering machine learning project, you will perform topic modelling in order to group customer reviews based on recurring patterns.

Loan Default Prediction Project using Explainable AI ML Models
Loan Default Prediction Project that employs sophisticated machine learning models, such as XGBoost and Random Forest and delves deep into the realm of Explainable AI, ensuring every prediction is transparent and understandable.