Forum Discussion

Rejaul84's avatar
Rejaul84
Frequent Visitor
2 years ago
Solved

Turn column headers into rows in a table visual

Is there a way where I can have the data headers to be a row and then the values to be in another column with out unpoviting?
Need Help
  • Anuja_Chaudhari's avatar
    Anuja_Chaudhari
    2 years ago

    Hi Rejaul84  today i have tried once again.

    this is my sample dataa..

    as you said you want header in row  without transpose and unpivot 

    first I have created this data and you would need to create a calculated table or use DAX measures to generate the desired result.

     Hope this is work for you  what you are expecting. 

    Thank you 

     

     

Anuja_Chaudhari's avatar
Anuja_Chaudhari
Helper I
2 years ago

I have tried with table matrix but it is not acchiving proper output

Rejaul84's avatar
Rejaul84
Frequent Visitor
2 years ago

I tried that but could not get to what I wanted. Thanks for trying.

  • Anuja_Chaudhari's avatar
    Anuja_Chaudhari
    Helper I
    2 years ago

    Hi Rejaul84  today i have tried once again.

    this is my sample dataa..

    as you said you want header in row  without transpose and unpivot 

    first I have created this data and you would need to create a calculated table or use DAX measures to generate the desired result.

     Hope this is work for you  what you are expecting. 

    Thank you