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 

     

     

Rejaul84's avatar
Rejaul84
Frequent Visitor
2 years ago

@Anuja_Chaudhari  Can you do this in the visual rather than transposing the data?

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