Forum Discussion

Ola's avatar
Ola
Frequent Visitor
9 years ago
Solved

Pivot text to table

  Is it possible to do a Pivot Text Table, with PowerQuery ?      Content Type  ---> Header Votes Comment Status Pivot tables and breakdown trees Header   Pivot tables and breakdow...
Need Help
  • Sean's avatar
    Sean
    9 years ago

    Ola It seems you need an additional column like in the picture (I've named it Idea Number) and then it works :smileyhappy:

     

Sean's avatar
Sean
Icon for Community Champion rankCommunity Champion
9 years ago

richbenmintz I think Ola should have posted this a sample data set based on the desired output

 

Content

Type

Pivot tables and breakdown trees

Header

6,505

Votes

62 comments

Comments

started

Status

Custom branding/colour scheme of dashboard (custom css?)

Header

3,085

Votes

66 comments

Comments

started

Status

send report or dashboard as email

Header

3,536

Votes

106 comments

Comments

started

Status

Refresh dashboards tiles when i change a report

Header

395

Votes

21 comments

Comments

started

Status

 

That's when you get the error!

richbenmintz's avatar
richbenmintz
Icon for Resident Rockstar rankResident Rockstar
9 years ago

Sean, not sure what error you are referring to? I was simply trying to answer the question as asked