Forum Discussion

Twinkie124's avatar
Twinkie124
Frequent Visitor
8 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