Problem with plotting all values on line graph

[LFM]

Hello. I have a dataset with 8760 rows. Im made a duration curve for spot on the y- axis and percent on the x- axis. When Im plotting the values into a line graph, it only shows the first listed values listed for the x- axis. The percentages should be illustraded from 0-100. I neither need to show percentages for all the values, but some intervals. How can I solve this?

[nandic · Accepted solution]

@LFM is your field Percentage of numeric or text data type?
If it is numeric, it should give you option to choose continuos x axis type. If it is text, it will not show you this option.
If it needs to be text, i would go with adding additional column where you would group values.
But i suggest to change data type to numeric and then format it as percentage. It will be cleaner.

[LFM]

Seems like I dont have this setup in PBI anymore. 

[nandic]

@LFM if percent value is to be shown on x axis and you would like to see all at once (without scrolling), select visual > go to formatting options > select X-axis > select Type = Continuos.

Alternative, add new column where you will create custom groups and then show these groups instead of each value.
Example, if percentage < 0.10, 10, if less then 0.20 then 20..

Cheers,
Nemanja