Transpose table with measure based on slicer

[krank1wagen]

Hi,

I have several data sheets that are linked together through value "Spec". I have a slicer that filters on spec, and all visual is updated. I have a table of max pressure and temperature for each spec in a excel sheet I use for data. But, I want it to be transposed. 

Here is the slicer showing the correct data for this "Spec". 

Here is the data, there is several lines each "spec":

Is there a way I can make the table looking more like this:

Thank you.

[Anonymous · Accepted solution]

Hi,

Thanks for the solution @Thejeswar  provided, and i want to offer some more information for user to refer to.

hello @krank1wagen , you can refer to the following solutions:

1.In power query, pivot the columns,click the Temp column, then click pivot column.

Output

2.As @Thejeswar  mentioned, use the matrix visual, put the following field to the visual.

Output

Best Regards!

Yolo Zhu

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

[krank1wagen]

Thank you and @Thejeswar 🙂

[Thejeswar]

Hi @krank1wagen ,

As far as I know, you cannot get a Horizontal view in the table visual that you are using.

As a work around, you can get this using Matrix Visual. But this requires some values to be in both Rows and Columns and the in your case the Deg.Cel column and Barg Column should be present in the values

Then change the column header font color to White. This is how it looks.

Regards,