Forum Discussion
Problem with plotting all values on line graph
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?
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.
3 Replies
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,
NemanjaSeems like I dont have this setup in PBI anymore.
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.
