Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
101 | |
78 | |
75 | |
49 |
User | Count |
---|---|
145 | |
108 | |
107 | |
89 | |
61 |