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