Area - Line Chats

Step 1: Import Data

• Open Power BI Desktop

• Click Get Data -> Excel/CSV

• Select your dataset

• Click Load

Step 2: Line Chart

• Select Line Chart

• Drag Order Date -> X-Axis

• Drag Order ID -> Y-Axis -> Count

• Rename title as Order Count

Step 3: Stacked Area Chart

• Select Stacked Area Chart

• Drag Order Date -> X-Axis

• Drag Sell -> Y-Axis -> Sum

• Drag Store Name -> Legend

• Rename title as Order value by Store

Step 4: Line Chart

• Select Line Chart

• Drag Order Date -> X-Axis

• Drag Order ID -> Y-Axis -> Count

• Go to the further analyses visual -> Turn ON Trend Line

• Rename title as Order Count

Step 5: 100% Stacked Ares Chart

• Select 100% Stacked Area Chart

• Drag Order Date -> X-Axis

• Drag Sell -> Y-Axis -> Average

• Drag Store Name -> Legend

• Rename title as Order Value by Store