Forum Discussion

RodolfoGalit's avatar
RodolfoGalit
Frequent Visitor
3 years ago
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...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    3 years ago

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

Ashish_Mathur's avatar
Ashish_Mathur
Super User
3 years ago

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