Forum Discussion

krank1wagen's avatar
krank1wagen
New Member
2 years ago
Solved

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 e...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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.