Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more

Reply
yjk3140
Helper I
Helper I

how to show individual values of the columns instead of sum

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!

 

 

1 ACCEPTED 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

View solution in original post

5 REPLIES 5
summerjandersen
New Member

I do not have the option "don't summarize" is there another solution?

maximik
Frequent Visitor

Where did I go wrong, if the field "don't summarize" does not appear? First possible choice is "Sum"?!

yjk3140
Helper I
Helper I

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

Syk
Super User
Super User

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

Syk_0-1647016199778.png

 

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors