Forum Discussion

NT204395's avatar
NT204395
New Member
5 years ago
Solved

Matrix visual visual not showing

I am creating Matrix visual using below table.  

 

 

But in the Matrix visual, it is only showing Project 10.  It supposed to show all 4 projects.  How do I fix it?  Thanks.

Need Help
  • v-xulin-mstf's avatar
    v-xulin-mstf
    5 years ago

    Hi NT204395,

     

    Is this what you want?

    If you still have some question, please don't hesitate to let me known.‌‌

     

    Best Regards,

    Link

     

    Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!

3 Replies

  • Pragati11's avatar
    Pragati11
    Super User
    5 years ago

    HI NT204395 ,

     

     

    Check the summarisation on Project Name column when you move it to matrix visual under the VALUES section.

    Power BI must have given it a default summarisation of First/Last as it is a text type column. You can non-summarise a column under VALUES section of matrix visual. Move it to ROWS/COLUMNS section.

    Add some screenshots for more details here.

     

    Thanks,

    Pragati

  • v-xulin-mstf's avatar
    v-xulin-mstf
    Community Support
    5 years ago

    Hi NT204395,

     

    Is this what you want?

    If you still have some question, please don't hesitate to let me known.‌‌

     

    Best Regards,

    Link

     

    Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!