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