How to compress line charts to create an overview without a slider?

[Anonymous]

Hi everyone,

I am currently creating a visual on powerbi, to be more specific a line graph, but I would like to create it similar to excel, when it is compressed in one big overview and not that I have to use the slider. I will attach a picture of random data I have chosen to showcase my problem, would love to hear from someone who has had a similar issue or just knows how to create this type of visual!

You can see the slider here, but i would like to compress this in one big overview, is it possible?

Thank you for your help! 🙂

[lbendlin]

That is the wrong chart type. Line charts can only be used for temporal progressions (like a date x axis).  Your countries are independent entities, use a column chart or a pareto instead.

Categorical x axis = horizontal scrollbar = bad, very bad.

[Anonymous]

Thank you for the reply but I think you have misunderstood my question, this dataset here is not important, it was just to show the visualisation problem i am facing, the true data is something else. The main question was how to compress such line graph in one overview, is it doable through powerbi visuals or python visuals or some custom ones? Like in Excel you can see the whole overview of the data although it looks squeezed ( in a line chart).

[lbendlin]

Use a continuous axis.

[Anonymous]

Yes, but I have 3 values in the x-asis and they are not date/time so it doesn't allow to switch between types either continuous or catagorical 

[lbendlin · Accepted solution]

Then the answer is no. Only works with continuous columns.