Forum Discussion

MarvinConceição's avatar
6 years ago
Solved

Converting Matrix into Cluster Chart

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

 
 

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

 

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

 

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

  • Hi MarvinConceição ,

     

    Like this?

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

     

    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.

2 Replies

  • v-lionel-msft's avatar
    v-lionel-msft
    Community Support

    Hi MarvinConceição ,

     

    Like this?

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

     

    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.