Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply

Converting Matrix into Cluster Chart

Hi guys, I need a hand, I have this Matrix 

 
 

image.png

I need to have it on a clustered chart having diferent colors based on the existing columns here, but what hapened is that

 

image.png

I can only get the result like this, and thats not practical, I need it to be grouped by the columns for each row and with the diferent colors accordingly.

I'm aiming for something like this

image.png

 

The data that fills the Matrix is not fixed, it can have more columns or lines, depending on the dataset, so it has to be dinamic.

 

can this be done? I greatly appreciate the assistance.

P.S.: I'm still new to Power BI

1 ACCEPTED SOLUTION
v-lionel-msft
Community Support
Community Support

Hi @MarvinConceição ,

 

Like this?

i2.PNG

Did you choose the right visual? Did you put the field on the correct label?

i3.PNG

 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-lionel-msft
Community Support
Community Support

Hi @MarvinConceição ,

 

Like this?

i2.PNG

Did you choose the right visual? Did you put the field on the correct label?

i3.PNG

 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @v-lionel-msft , that's precisely what I need, indeed I chose the right fields, but it seems I messed up in their locations, it was applying a drill instead

 

Thank you very much @v-lionel-msft 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.