Forum Discussion

DataAnalyst1's avatar
DataAnalyst1
New Member
3 years ago

Get line chart showing minute data between time thresholds

Hi all! 

 

I have some 1-minute data values that I want to show in a line chart. For example, some stock data between 8am to 4:30pm, and I would like to show this for an entire week, or month, or year, whatever the user requires. This should look like this:

Its a messy graph, don't mind that please, but it has what I want. A nice and clean x and y axis, data filtered between 8am to 4:30pm. This graph is made in Python with the broken axes library

If I try to do something similar in Power BI, I get to this:

It does filter out the data I don't want to show, but it keeps the x-axis running. If I change the graph to Categorical, it does filter the x-axis, but then it tries to show every single x-axis timestamp which also makes for an ugly graph. 

 

I probably could make the Categorical graph work for 1 example, but the problem is that my users might want to see 1 day, then switch to 5 days, then 1 month, then 1 year. I doubt I can create a solution that's flexible enough to keep the x-axis neatly organised. 

I have a data example file ready but don't see a way to attach it to this post, am I allowed to share files here? 

If any other info is needed, please don't hesitate to ask! 

1 Reply

  • Power BI has some limited safeguards in place to prevent you from doing overly "ambitious" things in your visuals. There are physiological limits, after all.

     

    Teach your users how to personalize visuals, how to use the filter pane, how to use zoom sliders and highlight areas.  That will make their UX much more pleasant and it will make your life much easier.