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

3 Replies

  • 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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Alina12 ,
    Based on the information you provided, I have a rough idea of your problem. After some testing it turns out that this is due to the design and it does happen when two fold lines intersect.This is caused by the fact that the gap between the current Actual and the next year's Target is filled when the two discounts cross, as shown below:

     

    You can submit an idea for it at:

    Home (microsoft.com)

    and wait for users with the same needs as you to vote for you to help make it happen as soon as possible.

     

    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.