Forum Discussion
Line Graph has dots?
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