Attribute as column header in table

[joshua1990]

Hi all!

I have a sales report that contains data for 10 weeks and that has this structure:

Date | Week | Value

Now 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.

[v-aatheeque]

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!

[v-aatheeque]

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!

[wardy912]

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.

[v-aatheeque]

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.!!

[Ritaf1983 · Accepted solution]

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