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

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.

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

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.