Forum Discussion

ajazz's avatar
ajazz
Frequent Visitor
5 years ago
Solved

Dynamic Reference Line on line chart

Hi there, I was wondering if it is possible to add a dynamic reference line to a line chart. In my line chart I have some filtered products by a slicer. On the y-axis i have price and x-axis i ...
Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    4 years ago

    Hi  ajazz ,

     

    Sorry for the late reply.

    Create 2 measures as below：

    Average =
AVERAGEX (
    FILTER (
        ALLSELECTED ( MedicinPriserUnpivot ),
        'MedicinPriserUnpivot'[Varenummer] = MAX ( MedicinPriserUnpivot[Varenummer] )
            && 'MedicinPriserUnpivot'[Dato] = MAX ( 'MedicinPriserUnpivot'[Dato] )
    ),
    'MedicinPriserUnpivot'[Pris]
)

    Measure2 =
VAR _tab =
    CALCULATETABLE (
        VALUES ( 'Vareoversigt'[Varenummer] ),
        FILTER (
            ALL ( Vareoversigt ),
            'Vareoversigt'[Substitutionsgruppe]
                IN FILTERS ( Vareoversigt[Substitutionsgruppe] )
        )
    )
RETURN
    CALCULATE (
        MINX ( ALLSELECTED ( MedicinPriserUnpivot ), [Average] ),
        FILTER (
            ALLSELECTED ( 'MedicinPriserUnpivot' ),
            'MedicinPriserUnpivot'[Dato] = MAX ( 'MedicinPriserUnpivot'[Dato] )
                && 'MedicinPriserUnpivot'[Varenummer] IN _tab
        )
    ) + 50

    And you will see:

    For the related .pbix file,pls see attached.

     

    Best Regards,
    Kelly

    Did I answer your question? Mark my reply as a solution!

v-kelly-msft's avatar
v-kelly-msft
Community Support
5 years ago

Hi ajazz ,

 

I see your data,how to caculate the reference line?

I took part of your data as below:

Could you pls advise me how to get the reference line?What is the calculation logic?

 

 

Best Regards,
Kelly

Did I answer your question? Mark my reply as a solution!

 

  • ajazz's avatar
    ajazz
    Frequent Visitor
    5 years ago

    Hi again,

    It needs to be average price per ProductNumber.
    Then a slicer to select 3-4 productnumbers.

    Of the "filtered" view, the reference line needs to take the ProductNumber with the lowest price and add +50 to it.

     

    Does that make sense?

    • v-kelly-msft's avatar
      v-kelly-msft
      Community Support
      5 years ago

      Hi ajazz ,

       

      Do you mean that the reference line is combined by loweast price of each month +50?

       

      Best Regards,
      Kelly

      Did I answer your question? Mark my reply as a solution!

      • ajazz's avatar
        ajazz
        Frequent Visitor
        5 years ago

        It needs to be for each date point, so not month. Like lowest price productnumber from monday 15 july 2019 + 50.