Forum Discussion

MJ1986's avatar
MJ1986
New Member
8 years ago
Solved

Making each column heading an x-axis label

I have some baby name data. In the first column, I have a long list of baby names. In the subsequent columns I have every year from 1900 to 2017, with the number of babies born with each name in each...
  • Drors's avatar
    Drors
    8 years ago

    I think that the easy way to handle it is to Unpivot your table :

    In the query editor, select the Name column -->right click --> Unpivot other columns

    Now you have table like :

    jon   2010   5

    jon   2011   4

    jon   2012   6

     

    after that in the line chart visual, put the year(attribute) in the axis feild the name in the Legend and the value in the value.

     

    Hope it will solve your problem

Drors's avatar
Drors
Resolver III
8 years ago

I think that the easy way to handle it is to Unpivot your table :

In the query editor, select the Name column -->right click --> Unpivot other columns

Now you have table like :

jon   2010   5

jon   2011   4

jon   2012   6

 

after that in the line chart visual, put the year(attribute) in the axis feild the name in the Legend and the value in the value.

 

Hope it will solve your problem