Forum Discussion
Line Chart (Last 12 weeks Trend)
Hi,
In the Query Editor, you should select the first column and "Unpivot Other columns". Rename the Attribute column to Date. Create a Calendar Table with a relationship (Many to One and Single) from the Date column of the Data Table to the Date column of the Calendar Table. To the X-axis, drag Date column from the Calendar Table. Write this measure and drag it to your visual
Measure - sum(Data[Value])
Hope this helps..
Try importing the Excel file directly into Power BI per the following:
Once imported, you'll then go to the Visualizations pane and select the Line Chart icon:
A blank chart will appear and the Visualizations pane will display the following fiels:
Take the fields imported from your Excel file and drop them into the respective Axes.
As you drop them in, the chart will begin visualizing the data and you can edit the fields to your liking.
Not the way I wanted, the Weeks count should be in X-axis not the Service Centers. How will I switch that
