Forum Discussion
Line Graph has dots?
Hi Twinkie124,
The root cause is that many values don't exist in the context even as a 0. We need to bring them in though they are 0s. Please check out the demo in the attachment.
1. Create a new table and establish a relationship.
Hours = VALUES(Sheet1[LOCALHOUR_INTEGER])
2. Create a new column like below and set its format as the snapshot shows. Why? Because the date hierarchy introduces new context.
Date = [LOCALINTERVAL].[Date]
3. Create a measure. I used 200 in the demo to show the effects clearly.
Measure = IF ( ISBLANK ( SUM ( Sheet1[Value] ) ), 0, SUM ( Sheet1[Value] ) )
4. Result is as follows.
Best Regards,
Dale
v-jiascu-msft,
The values that aren't included shouldn't be 0 though. They should be the last value that has been entered.
I want the data to look like this for example
Not like this which is what the given measure is producing:
Is there a measure that can be used to take the last given value? Like "Measure = IF ( ISBLANK ( SUM ( Sheet1[Value] ) ), Last Entered Value, SUM ( Sheet1[Value] ) )? Hope that is easy enough...I just don't know what it would be?
I also was unable to get the new Date column to work as you showed. Here is what I did:
It looks like the same settings as what you had, but this is what I get when I drag and drop the Date column into my graph.
Not sure why the Date column has all the extra subheadings underneath it...yours does not so if there is a way to change that, then I think we would be good on that issue.
Thanks for your continued help. I think we've almost got it.