Line Chart (Last 12 weeks Trend)

[RodolfoGalit]

Hi Experts, I am new to Power BI couldn't create a line chart in BI like I did in excel (see screenshot below ) which very simple from the data table i have also attach below. The data is based on the recorded % from the last 12 weeks. 'appreaciate all your help.. Thank you in advance!

[Ashish_Mathur · Accepted solution]

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..

[Alta88]

Try moving the Weeks into the X-Axis and the Service Center into the Y-Axis field. 

[RodolfoGalit]

How to expand? yours has X&Y, mine is just Axis

[Alta88]

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. 

[RodolfoGalit]

Not the way I wanted, the Weeks count should be in X-axis not the Service Centers. How will I switch that