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
PowerDau
New Member

Creat a chart like this...

Hallo guys, 

Im new to PowerBI and i try to create a simple chart. I got a reference to a excel chart. The problem is that PowerBi always use a calculation to my column. I only want to show values at a specific date. 

Here is a Screenshot from my Excel

http://prntscr.com/jl5l66

 

Thank you for your help!

Best regards

5 REPLIES 5
alexei7
Continued Contributor
Continued Contributor

This should work in a standard Line Chart visual in Power BI.

 

Can you screentshot what you see in Power BI and give a sample of your data?

 

Thanks

Here is what i see in powerbi. The problem is the sum of the values.. when I remove it powerbi will use another function like count

 

http://prntscr.com/jl6eud

 

Here is my data

 

http://prntscr.com/jl6g4

 

http://prntscr.com/jl6geb

 

thank your for your help!

 

greetings

 

 

 

 

alexei7
Continued Contributor
Continued Contributor

If you go to the "Modelling" tab of Power BI desktop, and then click on your values column, you should see an option in the middle called "Default Summarization". It usually defaults to sum, but you can change it to "Don't Summarize".

 

It could be that.

 

You may need to remove it and add it again for it to work

I tried this but when i use the unsummarized value, power bi automatically doing a calculation like count or sum.
How can i avoid this?

 

Greetings

Anonymous
Not applicable

Hi @PowerDau,

 

>>How can i avoid this?

It is impossible to avoid this, current chart only support to use summarized value on value field.

 

Regards,

Xiaoxin Sheng

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