Force showing all data points in a line chart

[Spigaw]

Hello dear problem solvers,

I ran into a small but annoying issue today. Last month and every month before yesterday, I was able to show all data points in my line charts, even if they are a bit cramped:

However, since maybe last week, the name of the X-axis changed by itself, my median line is no more, and a slider appeared which basically makes invisible all data points beyond a certain limit.

I can't find a way to revert to what I had before... Any help would be really, really appreciated.

Thanks in advance!

[johnt75 · Accepted solution]

If you don't need the drill up / drill down functionlity of the hierarchy then you could create a new column on your date table for Year Month which is a date representing the 1st of the month. Format that to just show the year and month ( that's one of the options in the format dropdown ). When you use this new column on your chart make sure that it is set to Continuous not Categorical and all the values will show on the chart without a scroll bar.

[Spigaw]

Thanks for your answer, I don't need the drill up/drill down.

I created the new column and added it as X-avis, but I can't find the Continuous and Categorical options in the chart. Can you tell me where to look for it?

Thanks!

[johnt75]

Its under the X Axis in the Visual section

[Spigaw]

I unfortunetaly can't see it :

I am using this version of PowerBI Desktop:

[v-easonf-msft]

Hi, @Spigaw 

As mentioned by @Spigaw , you may need to check the datatype of your X-axis variable. 

Only numbers and dates can be continuous.

If the problem has been solved, please accept @johnt75  reply as solution to close this thread.

If you still need help, please share a sample file for further research.

Best Regards,
Community Support Team _ Eason

[johnt75]

Is the column you're using set as type Date?