Forum Discussion
Attribute as column header in table
Hi all!
I have a sales report that contains data for 10 weeks and that has this structure:
Date | Week | ValueNow I would like to use the week number as the header in a table visual.
I know, this is possible using pivot / matrix visual. But is it possible to have the same functionallity using a table visual?
Date as the row, week as the column and the value as the value.
Hi joshua1990
In a standard table visual, there is no concept of “row vs column vs value” — each field is simply displayed as a column in the order it’s added. It doesn’t support pivot-like layouts.
However, what you're describing — Date as row, Week as column header, and Value in the cells — is exactly what the Matrix visual is designed for. The Matrix provides a pivot-style layout where you can define rows, columns, and values.
So if your goal is to display data in that structure, the Matrix visual is the right choice.
Like in my example of months that can be weeks in your case
If there’s a specific reason the Matrix doesn’t work for you, feel free to share a sample or mockup, and clarify what limitation you're encountering — we might be able to suggest an alternative workaround.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
5 Replies
Hi joshua1990
In a standard table visual, there is no concept of “row vs column vs value” — each field is simply displayed as a column in the order it’s added. It doesn’t support pivot-like layouts.
However, what you're describing — Date as row, Week as column header, and Value in the cells — is exactly what the Matrix visual is designed for. The Matrix provides a pivot-style layout where you can define rows, columns, and values.
So if your goal is to display data in that structure, the Matrix visual is the right choice.
Like in my example of months that can be weeks in your case
If there’s a specific reason the Matrix doesn’t work for you, feel free to share a sample or mockup, and clarify what limitation you're encountering — we might be able to suggest an alternative workaround.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Hi joshua1990
Can you provide an example of how you would like the data displayed, and why it has to be a table visual please?
The way you've described it, the matrix visual should be all you need.
Hi joshua1990
Just following up to see if the suggestions provided by wardy912 Ritaf1983 helped clarify your question regarding the use of a matrix visual instead of a table visual.
Since a table visual doesn't support pivot-style formatting (like setting Week numbers as column headers), the Matrix is indeed the recommended approach.
If the issue is resolved please kindly accept the solution. If you're facing a specific constraint that requires using a Table visual, feel free to share a mockup or clarify your requirements.
we’re happy to help explore alternative approaches if needed.
Thanks for being part of Fabric Community Forum.!!
Hi joshua1990
I wanted to follow up to see if the suggestions provided by Ritaf1983 helped clarify your question about using a matrix visual instead of a table visual.Since the table visual does not support pivot-style formatting (such as using Week numbers as column headers), the Matrix visual is indeed the preferred option. If your issue has been resolved, please consider accepting the solution.
However, if you have specific constraints that require the use of a Table visual, please share a mockup or provide more details about your requirements.We’re here to help you explore alternative approaches if needed.
Thank you for being a part of the Fabric Community Forum!
Hi joshua1990
I wanted to follow up to see if the suggestions shared earlier helped clarify your question about using a Matrix visual instead of a Table visual. Since the Table visual doesn’t support pivot-style layouts such as showing Week numbers as column headers the Matrix visual is generally the recommended choice.
If this resolved your issue, please consider marking the response as accepted, as it may help others with similar questions.
However, if you have specific reasons for needing to use a Table visual, please feel free to share a sample or describe your requirements in more detail.
We’re happy to help explore other options if needed.
Thank you for being part of the community!
