Pls help: categorical data in y-axis for stacked column

[phuongnguyen122]

I would like to ask about the stacked column in Power BI (as in the picture below). However, instead of showing the numerical data in Y-axis, I would like it to show the categorical data (i.e: instead of showing 1, 2, 3 I would like to show Red, Green, Grey….). The original data is categorical data (i.e: Red, Green, Grey..), but in order to create this stacked column I mapped all of them to numerical data, and I would like to show these original data in the y-axis.

Does anyone have any idea to solve this? 

[radhey_rec]

Hi @phuongnguyen122 ,

Can you post some sample data, preferably in tabular format and also the resultant chart you wish to see?

Thanks,

Radhey

[phuongnguyen122]

[phuongnguyen122]

Hello,

Here is the table format, and what I want to see. The category in the y-axis need to be in the same order as in the graph. The order of rating category (or the attribute) need to be fix as well (eg: the lowest is rating category 1, the highest is rating category 4).

Furthermore, the program name in X-axis belongs to country group, so I will need a filter by country to be able to see the programs per country.

What I did in my post is that I converted all the rating (B to AAA) to numbers from 1 to 14, and calculate the difference between  rating categories for each program. Then I plot the stacked column. However, I need the y-axis showing the rating (B to AAA) as in the second picture. 

[amitchandak]

@phuongnguyen122 , You have to explore charticulaor

Charticulator Part 1 - Bar and Bar Matrix: https://youtu.be/tKgG0arMaOw

Charticulator Part 2 - Scatter with Shapes: https://www.youtube.com/watch?v=QIPsv5hNbqI

[phuongnguyen122]

Hello, 

Thank you very much for your suggestion. What I need to do is just convert the y-axis to category (Red, green, grey etc), but I would like to keep the same chart (with the numerical label) as you are seeing here. From what I understand (after google...), the Charticulor cant do so.

I am not familiar with charticulor, so pls let me know if you find something similar there.

Thank you!