Forum Discussion
Transpose table with measure based on slicer
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.
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.
3 Replies
- Thejeswar
Super User
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,
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.
Thank you and Thejeswar 🙂
