Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more
Hi,
I'm new to PowerBI and I'm trying to make a line graph in PowerBI with my table which has 5 rows of 5 columns and one of the columns is created_time which is the same for all rows.
but the problem I'm facing when visualizing the data in powerBI is that it sums up all the values but doesn't show them indivisually.
What I want is to show the each values of the colums in a bar graph(there should be 4 bar graphs)
I would appreciate any help!
Solved! Go to Solution.
Oh you are putting your created_time as the axis! It's only finding one value so it aggregates them.
You could add an index value to your data! In the Power Query Editor click the add column tab and add an index column. Then put the index as your x-axis value
I do not have the option "don't summarize" is there another solution?
Where did I go wrong, if the field "don't summarize" does not appear? First possible choice is "Sum"?!
thank you @Syk for your response, I just tried it but I don't see "don't summarize" option in the list..
Oh you are putting your created_time as the axis! It's only finding one value so it aggregates them.
You could add an index value to your data! In the Power Query Editor click the add column tab and add an index column. Then put the index as your x-axis value
Power BI likes to automatically take the sum of a number. In your fields, click on the number you want to show individually and make sure the check mark is on "Don't summarize".
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 84 | |
| 49 | |
| 38 | |
| 31 | |
| 30 |