Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
Solved! Go to 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..
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
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