Forum Discussion

VinayakKarne's avatar
VinayakKarne
Frequent Visitor
6 years ago
Solved

Line Chart Visualization of multi-column tables

Hi Team,   I am facing one issue for visualizing the data in Line chart from a table. Consider the table as example.   JAN FEB  MARCH APRL MAY  JUNE JULY AUGUST SEPTEMBER OCTOBER NOV...
  • v-eachen-msft's avatar
    6 years ago

    Hi VinayakKarne ,

     

    Open query editor and select the "FY" and "Type" column, then click "Unpivot other columns". You will get a table like the following image.

    Now you could use it to get your visual(Attibute as x-axis and Value as values).