Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Colorizing/formatting a line up to today's date

I want to color the line of a chart up to a defined date. The rest of the line should be dashed.
For this I have already created two lines and superimposed them to format them differently. However, the end of the first line is disturbing, because a horizontal line is created.
Is it possible to hide the tail? or to format the same line to defined data sections?

 

Coloring
Date
Formatting
Line chart

3 Replies

  • ppm1's avatar
    ppm1
    Solution Sage
    3 years ago

    You can hide the blue "tail" by updating your measure so it returns blank for those points (e.g., Year > 2023 or Date > TODAY()).


    Pat

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Thank you for your message ppm1 . What should I change?

       
      Running Total Cost Today =
      CALCULATE (
          SUM ( PCT[Actual Total Cost (€)] ),
          FILTER (
              ALLSELECTED ( 'PCT' ),
              'PCT'[Period] <= MAX ( 'PCT'[Period] )
                  && 'PCT'[Period].[Date] <= TODAY ()
          )
      )
      • ppm1's avatar
        ppm1
        Solution Sage
        3 years ago

        Please try this measure instead. Note also that filtering a whole table is not best practice, so I removed that too.

        Running Total Cost Today =
VAR maxdate =
    MAX ( 'PCT'[Period] )
RETURN
    IF (
        maxdate <= TODAY (),
        CALCULATE ( SUM ( PCT[Actual Total Cost (€)] ), 'PCT'[Period] <= maxdate )
    )

        Pat