Forum Discussion
How to compress line charts to create an overview without a slider?
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! 🙂
Then the answer is no. Only works with continuous columns.
5 Replies
- lbendlin
Super User
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.
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.