Forum Discussion
VinayakKarne
6 years agoFrequent Visitor
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...
- 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).
v-eachen-msft
6 years agoCommunity Support
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).