Forum Discussion

Alina12's avatar
Alina12
Helper I
2 years ago

Coloring between two lines (linechart)

Hi to all   I have successfully coloured the space between my lines here, but I am always left with this small area. Does anyone have an idea what I can do?   Thanks in advance! ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Alina12 ,

On the basis of the information you have provided, can you explain what is meant by "always left with this small area". Does it mean that you do not want this area to have a fill colour or do you want it to be filled. Can you provide more examples of data to show the problem you are experiencing and what you expect the desired output to be.

 

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details with your desired out put and pbix file without privacy information.

 

Best Regards,

Ada Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Alina12's avatar
Alina12
Helper I
2 years ago

hi  Anonymous

Thanks for the answer for now. I only want to fill the area between the two lines in colour (positive as green and negative as red). Unfortunately, it always marks the area below the intersection of the lines in colour (see the marked red triangle in the screenshot above). The two measures that represent the lines are as follows:

Running Total_ASC_DeliveredValue =
VAR ActualSprintEndDate = MAX('Dim_Sprint Data'[SprintEndDate])
VAR TotalDeliveredValue = CALCULATE(
    [2ROW_DeliveredValue TOT],
    FILTER(
        ALLSELECTED('Dim_Sprint Data'[SprintNumber]),
        ISONORAFTER('Dim_Sprint Data'[SprintNumber], MAX('Dim_Sprint Data'[SprintNumber]), DESC) &&
        TODAY() >= ActualSprintEndDate
    )
)
RETURN
IF(
    TotalDeliveredValue = 0,
    BLANK(),
    TotalDeliveredValue
)
Running Total_ASC_BaseValue incl. ManagementFee (€) =
VAR ActualSprintEndDate = MAX('Dim_Sprint Data'[SprintEndDate])
VAR ActualSprintStartDate = MAX('Dim_Sprint Data'[SprintStartDate])
VAR TotalDeliveredValue = CALCULATE(
    [BaseValue incl. ManagementFee (€)],
    FILTER(
        ALLSELECTED('Dim_Sprint Data'[SprintNumber]),
        ISONORAFTER('Dim_Sprint Data'[SprintNumber], MAX('Dim_Sprint Data'[SprintNumber]), DESC) &&
        TODAY() >= ActualSprintEndDate
    )
)
RETURN
IF(
    TotalDeliveredValue = 0,
    BLANK(),
    TotalDeliveredValue
)

For solution I followd this blog post here: 

http://www.informationmagician.com/shaded-area-between-two-lines/

 But as you can see, it doesn't work properly for me. Hope this helps a little bit.