Forum Discussion

ciarangreene's avatar
ciarangreene
Advocate II
10 years ago

Non-continuous line chart data

Hi,   I have a table consisting of a date with four value columns which I've charted. Here:   I may not have all four values for every date, and when this happens, I don't want that part of...
Need Help
itchyeyeballs's avatar
itchyeyeballs
Impactful Individual
10 years ago

Have you tried the advanced time slicer here - https://app.powerbi.com/visuals/

 

May solve the scale issues as you can dynamically select periods and the axis adjusts automatically. Not sure if it will give an issue with categorical side of things though.

 

Edit - sorry just realised this visual only seems to accomodate one data series so probably not suitable

ciarangreene's avatar
ciarangreene
Advocate II
10 years ago

HarrisMalik,itchyeyeballs; thanks for the help guys. The solution I think is to aggregate (weekly) and then to have the more detailed daily chart elsewhere so a user can drill into it. It's that or I could try to create a custom visual which handles my data set a bit better. This simple test has already taken a chunk of time more that I thought it would! 

 

Thanks again,

/C

  • WillT's avatar
    WillT
    Community Admin
    10 years ago

    Hi everyone. At the moment, when you're using a continuous axis, Power BI always interpolates a straight line between points in the same series. We don't have an option to turn that off, but it's a good suggestion! Please post it on http://ideas.powerbi.com and we'll consider it for a future version!

     

    Thanks

  • greggyb's avatar
    greggyb
    Resident Rockstar
    10 years ago
    ciarangreene Drilldown on line charts is coming soon from what I hear, so in the future you will be able to use weeks as the default label on the axis and then drill into individual day values all within a single chart.
    • ciarangreene's avatar
      ciarangreene
      Advocate II
      10 years ago

      greggyb; thanks, I'll keep an eye out for these.