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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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