Filtering curves to not show straight horizontal sections

[Mike_Mace]

I have a graph with 3 running measures as per snip. I use a calendar based Dax code.

I want to use a filter to stop curves as a curve-visual and do not show the horizontal sections which do not bring any value to the visual. Ideas?

I'd prefer to not use the time filter because each curve will span on different timelines.

Thanks

curves

[v-easonf-msft]

Hi , @Mike_Mace 

If there is a horizontal section in the middle of the curve-visual, does it also not display or  show as 0?

It will be helpful ,if you can  provide some sample data and the formula of measure.

Here is a sampe.(please see report page1)

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Mike_Mace]

Hi @v-easonf-msft  ,

The visual on your page one is the neat graph I need to reach.

The calendar is daily, and the deliverables are on random dates, so Yes there are horizontal sections in the middle of the graphs.  Yes I need to be careful to not corrupt the data on those sections. Data on link.

I am conscious what amount of horizontal sections would be acceptable as the same due to pandemic effects on deliverables. Maybe experiment with 100/150days is an idea.

[Mike_Mace]

Hi @v-easonf-msft  again,

Tried your DAX, replaced with my measures but it doesn't seem to be working. 

I get an error on te use of measures. "Column Recovery Running in Table Recovery cannot be found or may not be used in this expression."

Could it becuase of the forumla that I use for calculating Running amount?

Recovery Running =

CALCULATE(

    (SUM('Recovery'[Recovery]) + SUM('Actuals'[Actual])),

    FILTER(

        ALLSELECTED('Date Calendar'[Date Calendar]),

        'Date Calendar'[Date Calendar] <= MAX('Date Calendar'[Date Calendar])

    )

)

[v-easonf-msft · Accepted solution]

Hi , @Mike_Mace 

Please refer to this demo.

Take the measure "Actual Running" as an example.You only need to add an if condition to the measure.

Actual Running2 = 
var _date = SELECTEDVALUE('Date Calendar'[Date Calendar])
var _maxdate = 
CALCULATE(
    MAX(Actuals[Actual Date]),
    ALLSELECTED(Actuals)
)
return
IF(
   _date<=_maxdate,
    CALCULATE(
        SUM('Actuals'[Actual]),
        FILTER(
            ALLSELECTED('Date Calendar'[Date Calendar]),
            'Date Calendar'[Date Calendar] <= MAX('Date Calendar'[Date Calendar])
        )
    )
)

The result is show as below:

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Greg_Deckler]

This is going to depend on your data and whether you can compare the current value with the previous value and how many previous values need to be the same before you "quit".

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490