Exclude Weekends in Line Chart

Team, In the line chart can we exclude the Weekends? The dataset that i have does not have data for Weekends because of that i am not able to make use of isworkday function or the Extract function to filter the data.
I see when pulling in Line Chart all the dates are getting populated. Is there way to exclude the Weekends? Please let me know.

Thanks,

Hi @arul and welcome to the QuickSight community!
I was able to find an old community post that had a similar request, check out the solution provided here and let us know if this may work for your case:

Hi @Brett , Thank You for the reply.

I had tried the above mentioned option. The Problem there is, i have dataset that does not have Weekend dates included.
Below is an example:

Date Count
9-Apr 5
10-Apr 10
11-Apr 150
14-Apr 200

i expect the Line chart not to have X axix value for 12th April and 13th April as it is not there in Dataset.
But the line chart by default populates 12th and 13th APril. Is there way to restrict the weekends from Line chart.