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.
Hi Twinkie124,
Please check out the demo in the attachment. It's based on your description.
Regarding the dates in the x-axis, it a MMDD day. We need to use it directly instead of its hierarchy.
Measure 6 = VAR latestdate = CALCULATE ( MAX ( Sheet1[LOCALINTERVAL] ), FILTER ( ALLEXCEPT ( Sheet1, Sheet1[DAYSAHEAD] ), Sheet1[LOCALHOUR_INTEGER] < MIN ( Hours[LOCALHOUR_INTEGER] ) ) ) VAR lastValue = CALCULATE ( MAX ( Sheet1[Value] ), FILTER ( ALLEXCEPT ( Sheet1, Sheet1[DAYSAHEAD] ), Sheet1[LOCALINTERVAL] = latestdate ) ) RETURN IF ( ISBLANK ( SUM ( Sheet1[Value] ) ), lastValue, SUM ( Sheet1[Value] ) )Best Regards,
Dale
v-jiascu-msft, Just wanted to let you know that I haven't forgotten about your response. My power BI desktop is currently not working for me and I can't even open up Power BI Desktop. So I can't open your demo.
Not sure if you would know who to ask about the error: "Unable to start Power BI Desktop-We weren't able to connect to the model"? I tried uninstalling and updating the version but it still doesn't work. Or would you know how to troubleshoot this issue?Hi Twinkie124,
That's weird. Did you use the latest version of Desktop? I would suggest uninstall it and restart the computer and then install the latest version. I downloaded the file from my last post. It's good on my side.
Best Regards,
Dale
v-jiascu-msft, Yeah I will have to get my my company's IT department to do that as I can't do it myself here. It may take a while for them to get around to it, but I will ask and let you know when that is done and if it is working. I also have someone who I am working with who is on vacation right now who said he had problems getting Power BI to work for him as well. I will talk with him beginning of next week too and see if we can resolve the issue.
Thanks for the help