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 the line to render. Excel handles this as I would like:   

 

Is there any way of configuring Power BI not to interpolate and render a line for missing data?

 

Also; I've noticed that the 'values' for a chart always have some sort of aggregation (Sum, Count, Avg, etc). Is it possible to just chart the raw data values?

 

Thanks,

Ciarán

Need Help

15 Replies

  • HarrisMalik's avatar
    HarrisMalik
    Continued Contributor
    10 years ago

    ciarangreene I think what you are looking for is Categorical axis. You can open the format tab while selecting the visual and in X-Axis change the type from continious to categorical. I hope this helps you.

     

    • ciarangreene's avatar
      ciarangreene
      Advocate II
      10 years ago

      HarrisMalik Ah! Sweet. It's an improvement, thank you, but this results in a scroll bar appearing for the X-Axis whereas I'd like to see everything at a glance.

      • HarrisMalik's avatar
        HarrisMalik
        Continued Contributor
        10 years ago

        ciarangreene The scroll bar normally appears when you have too many members on an axis. Can you share a screenshot?

  • sturossPD's avatar
    sturossPD
    New Member
    4 years ago

    I have not found a solution that works for large non-continuous time data sets. 

     

    x-axis to categorical is not a solution for large data sets. scrolling is not a solution if one is trying to print an output.

     

    creating additonal rows in database to fill in the gaps with 0's is not an efficient of cheap solution either.

     

    Based on number of votes on Idea below very few PowerBI users are working with large non-continuos data sets and impacted by this.  Frustrating but only real option may be to look at another tool other than PowerBI.

     

    http://community.powerbi.com/t5/Desktop/Non-continuous-line-chart-data/m-p/13746 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    hi ciarangreene 

    Here, is a Non-continuous line chart where you can put your broken data in a line chart and get an appropriate result.Non Continuous Line chart. pbivizedit.com

     

    Download link for the custom visual file on this page,

    https://pbivizedit.com/gallery/non-continuous-line-chart 

     

    This was made with our Custom Visual creator tool PBIVizEdit.com. With this tool,

    • anyone, irrespective of technical skills, can create their visuals
    • 15 minutes to create a visual from scratch
    • opens up many additional attributes to edit (e.g. labels, tooltips, legends position, etc)

    Give this a shot and let us know if you face any problems/errors.
    You can use the editor to modify your visual further (some modifications cannot be done in the Power BI window and have to be in the editor).

     

    Thanks,
    Team PBIVizEdit