How to correct the axis into 0 to 100% in line graph?

[bourne2000]

Hi

I am having below data,

I would like to create a graph of date vs sales percentage in general and having Sales ID as a filter. However, when I tried to make that line graph, I am not able to get the axis correct. My sales (%)  column value in % and I would like to want the axis in 0 to 100%. Below is the output I am getting. I tried don't summrize option as well.

I am looking for a below ouput. I generated this in excel. 

Can anyone guide me how to do this?

My sampe pbix here https://we.tl/t-dB9JDyAg6B

[v-angzheng-msft]

Hi, @bourne2000 

Glad to see your problem solved. Is my answer above helpful?😀

Could you consider sharing your solution? It will help the others in the community find the solution easily if they face the same problem with you. Thank you. 

Best Regards,
Community Support Team _ Zeon Zheng

[v-angzheng-msft]

Hi, @bourne2000 

Since you have duplicate rows in your data, you can change the summary method to Average.

And change the type of X-axis to "categorical"

Then you can get the result

Please refer to the attachment below for details. Hope this helps.

Best Regards,
Community Support Team _ Zeon Zheng

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

[AllisonKennedy · Accepted solution]

@bourne2000 it looks like you have lots of % values for the same date for a single sales person. In order to plot these all on a line graph, you must convert them into a single value. How do you want to do this? MAX? AVERAGE? Don't summarize is not working because there is more than one value per date.

Also, just confirming you have a date table? https://excelwithallison.blogspot.com/2020/04/dimdate-what-why-and-how.html This will help ensure you have a 'continuous' axis - which is something you can set in the format options for the visual in Power BI.