Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Dynamic Reference Line

I have a line graph showing trend lines for prices of multiple commodities. I need a vertical reference line (dynamic) on this graph to differentiate between the current and forecast values on the X-...
Need Help
  • v-yingjl's avatar
    v-yingjl
    5 years ago

    Hi Anonymous ,

    You can create measure to calculate specific period values and show it in the line chart:

    Measure = 
CALCULATE (
    SUM ( 'Table'[Sales] ),
    FILTER (
        'Table',
        'Table'[Category]
            IN DISTINCT ( 'Table'[Category] )
                && 'Table'[Date].[MonthNo] >= MONTH ( TODAY () )
                && 'Table'[Date].[MonthNo]
                    <= MONTH ( TODAY () ) + 1
    )
)

     

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

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
5 years ago

create a measure that computes this, and add it to the visual values