Is there a way to format a table visualization to show column headers next to values?

[Angela_Rom]

I am attempting to recreate a report within Power Bi. I am trying to format the table visualization to mirror the PDF verison of the report but I cannot figure out if there is a way to place column headers next to values. I am looking into formatting options but I do not see anything that would allow me to change the column header to be alongside the value. Please see the examples provided below and let me know if there is anything that I can do in order to produce the formatting that I would like to have in my report.

[RMDNA]

Unless I'm misinterpreting your issue and Greg has it down:

What are the column headers for the two columns? If you format your data in a way that "status," "flag," etc. are an "Attribute" column and the values belong to a "Value," just use a table or matrix visual to get what you want.

If your data is formatted with "status," "flag," etc. as their own columns, just unpivot the table.

[Angela_Rom]

The attributes are individual columns. I see how you unpivoted the table but I tried this and it would not go through. I think there is too much data in my query. All these columns are values for a stock number. I did use the matrix table and formatted it in a way in which the rows are alongside the values but now the last row is not visible. Does anyone know how to resolve this issue?

[Angela_Rom · Accepted solution]

I had to add an additional field into the column field and alter the table view so that it would show only the information but the workaround resulted in capturing the format view I wanted.

[Greg_Deckler]

Well, you could create an enter data query like:

Column1,Sort

status,1

flag,2

last date,3

date,4

inspect,5

code,6

desdate,7

Set your Sort By column to Sort for Column1. Put Column 1 in a table visual. Then create a measure like:

Measure 5 = 
SWITCH(
    MAX([Column1]),
    "status",MAX(Table6[status]),
    "flag",MAX(Table6[flag]),
    BLANK()
)

Put that in your table. Obviously, you will have to make that measure match your data and what you are trying to do.