I can't show all the data in line chart would you help ?

[Anonymous]

When I export the data from the line and stacked column chart I get the results on the excel. But as you see, I can't show all the cycle time result on the line chart ? Is there anyone have experienced like this ? I tried so many ways but I couldn't make it. Is there any opinion how can I solve this ? Thank you for spending time! Have a nice day!

[Anonymous]

Hi @Anonymous ,

Please pay attention to the limitations.

Export data from a Power BI visualization - Power BI | Microsoft Learn

The maximum number of rows that the applications can export to an .xlsx file is 150,000. The actual number may be lower than 150,000 depending on query limits and visual types.

he granularity of data exported to Excel using the Data with current layout and Summarized data options are identical and the only difference between the options is the shape of the data in Excel. For example, in a matrix visual, the Data with current layout preserves the shape of the visual as shown in Power BI when data is exported to Excel while the Summarized data option exports the same data but as a flat table of rows and columns.

Please use the latest version of Power BI Desktop.

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Rongtie

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

[Ritaf1983]

Hi @Anonymous 

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

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