Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
Anonymous
Not applicable

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!

 

First.PNG

Second.PNG

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! 🙂

1 ACCEPTED SOLUTION

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

View solution in original post

5 REPLIES 5
lbendlin
Super User
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.

Anonymous
Not applicable

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).

Use a continuous axis.

Anonymous
Not applicable

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 

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

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors
Top Kudoed Authors