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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

0

Line chart broken with certain data

With certain data, line charts fail to be correctly drawn/updated in powerbi web client.

Table and bar chart views are fine with the same data, also the same line charts work in powerbi desktop client.

Also, the data itself seems to be correct in the chart, since hover labels are correct. See screenshot below.

 

Example:

 

bad_linechart.png

 

Below is example data that gives me 100% repro (make a line chart, choose val as value, add date as axis, add slice and date to that, try to filter by date):

 

date,val
2017-08-08,0.0296482715982
2017-08-10,0.0298678868113
2017-08-11,0.0301299951606
2017-08-12,0.0312995650853
2017-08-13,0.0306366969794
2017-08-14,0.0295531838109
2017-08-15,0.029502330513
2017-08-16,0.0290743731735
2017-08-17,0.0292233754248
2017-08-18,0.0298246608105
2017-08-19,0.0310281651361
2017-08-20,0.0305999365758
2017-08-21,0.0294747029128
2017-08-22,0.0293544157992
2017-08-23,0.029372531421
2017-08-24,0.0294616955569
2017-07-15,0.0308341492194
2017-07-16,0.0300575038167
2017-07-17,0.0287802445964
2017-07-18,0.0291740180106
2017-07-19,0.0289400053455
2017-07-20,0.0292499466782
2017-07-21,0.0293311329802
2017-07-22,0.0303914462471
2017-07-23,0.0299422319804
2017-07-24,0.0291453316984
2017-07-26,0.0293508575366
2017-07-27,0.0298511300009
2017-07-28,0.0299696653444
2017-07-29,0.0308738096563
2017-07-30,0.030789060956
2017-07-31,0.0296178140777
2017-08-01,0.029421688848
2017-08-02,0.0292871794854
2017-08-03,0.0286048582998
2017-08-04,0.0295235475018
2017-08-05,0.0309004918692
2017-08-06,0.0306991594324
2017-08-07,0.0295011146686
Status: Delivered
Comments
v-qiuyu-msft
Community Support

Hi @andosa,

 

I'm not able to reproduce the issue on my side.

 

q8.PNG

 

1. Please duplicate the line chart, change X-axis type as Categorical. Then republish the report to see if the line chart display fine.

2. Please try to run the latest Power BI desktop version 2.49.4831.521 to create the report.

3. You can download our test LineChart.pbix file, then publish to your Power BI service to see if the issue related to your service cluster.

 

Best Regards,
QiuyunYu

Vicky_Song
Impactful Individual
Status changed to: Needs Info
 
andosa
New Member
  • I downloaded your pbix, made sure I have 2.49.4831.521
  • The chart looks fine in powerbi desktop
  • After publish, line charts are still broken, see screenshots below

 

  • After changing the slicer to a shorter period, line chart appears

 

  • After changing slicers back, chart does not update

v-qiuyu-msft
Community Support

Hi @andosa,

 

The issue should be related to your Power BI service itself, please create a support ticket:

 

Support Ticket.gif

 

Best Regards,
QiuyunYu

Vicky_Song
Impactful Individual
Status changed to: Delivered