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! Request now

Reply
kupradzeg
Regular Visitor

Same data from different DBs building Line Chart in Different Ways

Hello; Using my data that is provided in the reports below, I am trying to build demand and supply curves; In example 1, when I put "Min of Price" in the Value, the curves are drawn in the right way and no information is missing; Here is the graph and table of the first example:

Capture.PNG

 

Capture.PNG

 

When I transferred my information to another DB, and did exactly the same thing, it started missing some values, and no it is building a line chart differently, but I cannot understand why and what causes this. I have tried everything - Turned Values and Prices to "DO not summarize" what seems like it still summarizes or takes specific values and misses some of the important points. Here is the graph and table from example 2:

Capture1.PNG

Capture.PNG

 

 

P.S. How do I get that in the second graph I have the wrong graph? Because both, demand and supply curves should have their maximum and minimum points as -200 and 1000; In example 1 you can see that those points are always maintained, but the same cannot be said regarding the second example;

 

1 REPLY 1
v-chenwuz-msft
Community Support
Community Support

Hi @kupradzeg ,

 

Do you mean that in example 2, the data after 800 of type 2 is missing?
Please check if there is data after 800, you can convert the line chart to table visual to see.
Have you applied some filters? Try creating this line chart on a blank page.

 

Please share your pbix file without sensitive data if you need more help.

 

Best Regards

Community Support Team _ chenwu zhu

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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