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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
ciarangreene
Regular Visitor

Non-continuous line chart data

Hi,

 

I have a table consisting of a date with four value columns which I've charted. Here:

PowerBIChart.png

 

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:   

ExcelChart.png

 

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

15 REPLIES 15
Anonymous
Not applicable

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

 

sturossPD
New Member

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 

HarrisMalik
Continued Contributor
Continued Contributor

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

 

Categorical.jpg

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

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

@HarrisMalik Unfortunately I can't share a screenshot... I'm getting an error message: "Uploading PowerBIScreenshot.jpg resulted in the following error: You have already uploaded 1,000 images during this 24-hour window. You can try to upload more images later." This comes as a bit of a surprise as I've only uploaded 2... ever. This isn't a PowerBI issue... its just kind of funny.

 

The scrollbar only appears when I altered the axis to categorical. I could potentially average by week which would reduce the rows to 52, but I'm loosing granularity. Is this my only option?    

 

The data table I'm using has 366 rows, a date column from 2015-01-04 to 2016-01-04 inclusive which serves as the X-Axis and then the four value columns.  

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

@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

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

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

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

This question/feature request was posted on January 2016, do we have a solution for this now? Can you share the solution if this was implemented?

Thanks

 

JR89
Regular Visitor

Hi, has this issue been addressed? I'm struggling with the same thing. 

@ciarangreene 366 unique values for date cannnot fit in one frame and still readable. Power BI is intelligent enough to put a scroll bar underneath.

 

There are couple of options you can try:

 

1. Change the data type of date column to Date if it is text, Power BI will automatically rollup the dates labels to months but you can still see the values per day by hovering over the chart.

 

2. You can also use the custom visual "Advanced Time Slicer" and interactively scroll through your selected range.

 

Regards

 

Harris

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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