Forum Discussion

chillpill's avatar
chillpill
Icon for Helper III rankHelper III
2 years ago
Solved

Column values from table showing up as headers in matrix visual

I have a Matrix visual which is showing the values of a column. The column header should be listed here instead (Scheduled Hours & Total Production Hours) and the values within the rows (which are a list of names). Not sure what is causing this.

 

  • Hi chillpill,

     

    You put the two fields in Columns... so they're showing up in your columns. If you want them to show up as values, you need to put them in Values. 🙂

     

    (Keep in mind that if you want it to be under values, they need to be aggregated in some way.)


    ----------------------------------
    If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)

  • Anonymous's avatar
    Anonymous
    2 years ago

    Thank Wilson_   for your prompt reply.

    Hi chillpill   ,

    Depending on the information you have provided, I created a sample data to help you solve your problem. You can follow the steps below.
    Sample data:

    Put Owner in Rows, Scheduled Hours & Total Production Hours in Values.

    Final output:

    How to Get Your Question Answered Quickly - Microsoft Fabric Community

    If it does not help, please provide more details with your desired out put and pbix file without privacy information.

     

    Best Regards,

    Ada Wang

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

2 Replies

  • Wilson_'s avatar
    Wilson_
    Icon for Memorable Member rankMemorable Member

    Hi chillpill,

     

    You put the two fields in Columns... so they're showing up in your columns. If you want them to show up as values, you need to put them in Values. 🙂

     

    (Keep in mind that if you want it to be under values, they need to be aggregated in some way.)


    ----------------------------------
    If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)

  • Anonymous's avatar
    Anonymous
    Not applicable

    Thank Wilson_   for your prompt reply.

    Hi chillpill   ,

    Depending on the information you have provided, I created a sample data to help you solve your problem. You can follow the steps below.
    Sample data:

    Put Owner in Rows, Scheduled Hours & Total Production Hours in Values.

    Final output:

    How to Get Your Question Answered Quickly - Microsoft Fabric Community

    If it does not help, please provide more details with your desired out put and pbix file without privacy information.

     

    Best Regards,

    Ada Wang

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