Forum Discussion
Solved
Line Chart (Last 12 weeks Trend)
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 th...
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 moving the Weeks into the X-Axis and the Service Center into the Y-Axis field.
How to expand? yours has X&Y, mine is just Axis
