Issue with default Area chart in Power BI

Question

I am facing issues while solving one of the requirements.

when there are too many values in X axis, then certainly we can't show the area chart without a scrol bar as shown below. The requirement is to show everything in Area chart without Scroll Bar. Here the values are too large hence it's impossible to show like requested.

I found a custom visual (Advanced Area Chart | PBI VizEdit) which solves the problem as shown below, however purchase is required for this visual.

Is there anyway, I could solve this problem without have to pay for any visual? Could this be achieved by some DAX or formating technique or anything?

Your help would be highly appreciated.

Thank you.

lbendlin · Answer

Specify a custom max value for your X axis. Sample ever tenth datapoint (for example)
&nbsp;
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot). https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216 Please show the expected outcome based on the sample data you provided. https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Forum Discussion

Issue with default Area chart in Power BI

1 Reply

Related content

Line Chart Issue

Data Factory Pipeline Default Identity Issue

Stacked Column Chart Data Limit Issue

Expanding tree chart altogether as default.

Averagex issue