Two Measures to Draw One Line

[MPetramalo214]

Hi everyone, let me preface this by saying I'm not sure the requested feature is entirely possible.

What I'm trying to do is create two separate measures for a line chart.  I want the measure to check the last day of the dataset, and if we're meeting or above goal; it should draw the entire line.  Second measure does the same thing, just if we're below goal.

A couple important items that may help:

1) I'm tracking running sales and a running sales goal this looks something like

2) The last day of the mock dataset is 1/6/22

3) Here is what I'd envision the table looking like if the measures were working as intended.

Above Goal (as of 1/6):

Below Goal (as of 12/16):

Unfortunately, the way its currently calculating is

Measures to note:

Running Sales = 
CALCULATE(
    SUM(Sheet1[Sales Actual]),
    FILTER(
        ALLSELECTED(Sheet1[Date]),
        ISONORAFTER(Sheet1[Date], MAX(Sheet1[Date]), DESC)
    )
)

Running Goal = 
CALCULATE(
    SUM(Sheet1[Sales Goal]),
    FILTER(
        ALLSELECTED(Sheet1[Date]),
        ISONORAFTER(Sheet1[Date], MAX(Sheet1[Date]), DESC)
    )
)

Above Goal = 
IF([Running Sales] >= [Running Goal], [Running Sales], BLANK())

Below Goal = 
IF([Running Sales] < [Running Goal], [Running Sales], BLANK())

Any sort of guidance would be greatly appreciated.

[v-kkf-msft]

Hi @MPetramalo214 ,

Are you trying to show different colors on the same line, like this?

Currently Power BI does not support conditional formatting of the color of the line chart, you can suggest your idea here.

https://ideas.powerbi.com/ideas/idea/?ideaid=0671c26d-bd0e-43ad-b78c-bb097f2c54af 

Just as a workaround, you can try other visuals or superimpose two fold lines as follows.

Put the measures into the Values/Secondary values pane separately, then close the legend, set the color of [Above Goal] and [Running Sales] to the same, and turn on the "Series labels" option.

Then the final result will be:

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[MPetramalo214]

I'm not trying to get one line with two colors; I actually was trying to force one line to be conditional on if we're above goal on the max day we're filtered to, and the other to be conditional on if we're below goal. 

Which ever is true, would draw the line - and because its two measures, I can manually set the color of each.

All the following is being manually manipulated by me; but is how I would envision this working.  But I understand if this is not a feature yet.

Above Goal:

Below Goal:

The problem I am currently running into, is that instead of the entire series of dates being calculated by each measure; the measures are only calculating when that day is above/below goal:

[lbendlin]

Please provide sanitized sample data that fully covers your issue. Paste the data into a table in your post or use one of the file services. Please show the expected outcome.