Forum Discussion

Twinkie124's avatar
Twinkie124
Frequent Visitor
7 years ago

Line Graph has dots?

I am using Power BI Desktop and am trying to create a line chart with varying interval durations. The interval durations are the way they are for a reason.  However, the line chart is not connec...
Need Help
Twinkie124's avatar
Twinkie124
Frequent Visitor
7 years ago

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.

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
7 years ago

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] ) )

dots

 

 

Best Regards,

Dale

  • Twinkie124's avatar
    Twinkie124
    Frequent Visitor
    7 years ago

    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?

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    7 years ago

    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

  • Twinkie124's avatar
    Twinkie124
    Frequent Visitor
    7 years ago

    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