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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.

Not able to see all data points in line chart since the data size is huge

Issue : Not able to see all the data points in the line chart even when there is data for that X axis value. Please find below screenshot for reference : 

Screenshot 1 : Data points for the highlighted X axis value is not seen on the line chart even when data is present for that X axis value

 

namdevmunde_0-1658398099101.png

 

 

Screenshot 2 : When filtered for those highlighted values, data points are seen

namdevmunde_1-1658398099108.png

 

 

Few other details which might be useful : 

 

Total number of rows in data : 891,153

Size of the PBI file : 129,600 KB

 

Is there any way to display all the data point in one line chart without applying any filter?

 

More Details about source and PBI :- 

 1. Source data is xlsx files and file size is approximate 700 MB

2. Scale manipulation is not possible since X axis is not continuous and there is a no impact while changing Y axis.

3. Using other chart types for same data not possible because we must use line chart as per business requirements.

4. We dont have any blank valuses in x and y axis. 

Status: Needs Info

What is the data size have you used in this issue is huge, you can consider providing more details and screenshots about it.

 

In addition, when you use the line chart in Power BI Desktop, have you noticed that whether there is a blue exclamation mark in the visual about the data size.

 

Best Regards,
Community Support Team _ Yingjie Li

Comments
v-yingjl
Community Support
Status changed to: Needs Info

What is the data size have you used in this issue is huge, you can consider providing more details and screenshots about it.

 

In addition, when you use the line chart in Power BI Desktop, have you noticed that whether there is a blue exclamation mark in the visual about the data size.

 

Best Regards,
Community Support Team _ Yingjie Li

namdevmunde
New Member

Here is the More Details @v-yingjl , Thanks a lot for quick response , Really appreciate your help on this. 

Issue : Not able to see all the data points in the line chart even when there is data for that X axis value. Please find below screenshot for reference : 

Screenshot 1 : Data points for the highlighted X axis value is not seen on the line chart even when data is present for that X axis value

 

namdevmunde_0-1658398685137.png

 

 

 

Screenshot 2 : When filtered for those highlighted values, data points are seen

namdevmunde_1-1658398685090.png

 

 

 

Few other details which might be useful : 

 

Total number of rows in data : 891,153

Size of the PBI file : 129,600 KB

 

Is there any way to display all the data point in one line chart without applying any filter?

 

More Details about source and PBI :- 

 1. Source data is xlsx files and file size is approximate 700 MB

2. Scale manipulation is not possible since X axis is not continuous and there is a no impact while changing Y axis.

3. Using other chart types for same data not possible because we must use line chart as per business requirements.

4. We dont have any blank valuses in x and y axis. 

namdevmunde
New Member

@v-yingjl  yes we can see the blue exclamation mark in the visual about the data size and it says that too many values. Not showing all data.

namdevmunde_0-1658401721062.png