Forum Discussion
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?)- Anonymous2 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_
Memorable 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?) - AnonymousNot 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.