Forum Discussion
X-axis categorical line chart without scrollbar
Hello,
I have a dataset with a variable Interval in hh:mm:ss, which I use on the x-axis of a line chart. Interval data has the category Time and consists of intervals of approximately 30 seconds for 1 hour (00:00:00 until 01:00:00). If I use the X-Axis Type Continuous setting, the chart is plotted in 'one' view without scrollbar at the bottom of the chart. This setting shows the time from 12:00 AM - 1:00 AM. I need to have the time represented in hh:mm:ss on the x-axis of the chart. If I use the Categorical Type for the X-Axis I get the correct time representation, but I get a scrollbar at the bottom of the chart to scroll through time. This is not useful for our situation. Is there a way to display the data in 'one' view without the scrollbar? So that you see all data for the whole hour at one glance?
Thank you for the help.
7 Replies
- v-juanli-msft
Community Support
Hi Anonymous
As tested, I don't find any option to make the line chart look like what you like.
i work with a custom visual called "drill down column chart for time based data"
Hope this can be a available workaround for your scenario
Reference:
https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104380881?tab=Overview
Best regards
Maggie
- AnonymousNot applicable
Hi Maggie,
Thank you for your reply. Unfortunatly this is not the workaround we are looking for. The graphic needs to be a line chart like in my original post. But again, thank you for helping.
Regards,
Cas
- ryan_mayu
Super User
Anonymous
I think this is becuase too many values on X-axis. Maybe you can try group values to reduce the amount of values.
- AnonymousNot applicable
Hello ryan_mayu,
I think grouping the values worked, thank you! :smileyhappy:
The values on the X-axis are displayed diagonal, is there a way to display them vertical? Like in the second image of my original post. I have tried the X-axis Format options, without result.
- ryan_mayu
Super User
Anonymous
I changed the type to Categorical in x-aixs property. I am not sure if this can solve your problem. You can try this.