Forum Discussion

JRocas's avatar
JRocas
New Member
9 years ago

Dynamic Reference Lines in Legend

  Is there a way to include the average line (or any of the dynamic reference lines) into the visual's legend?  
Anonymous's avatar
Anonymous
Not applicable
9 years ago

JRocas, what type of chart are you using? One potential option could be to create a measure for the average (or whatever other reference you are looking for) and then graph that in your chart alongside your other measures. That would then add the reference to the legend.

 

This would likely only work for line charts or for bar charts (if you change to combo chart and put the average measure as the line).

JRocas's avatar
JRocas
New Member
9 years ago

I'm using a line chart. Thanks for your input. However (this comment is more directed to Power BI developers), having to create a measure for the average in order for it to show in the legend takes away from the convenience of using dynamic reference lines. Convenience is especially relevant for users like myself who don't have a developer/coding background to build measures on the fly.

  • v-sihou-msft's avatar
    v-sihou-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    JRocas

     

    In Power BI Dekstop, the line chart can't generate dynamic average lines automatically. Anonymous is correct. In a line chart, one line means a field, so to include average line, you have to create average field in your dataset (either calculated column or measure). And it can't be a dynamic aggregation type. You need to define it in your formula. To create an average measure, please refer to formula below:

     

    Average Amount = CALCULATE(AVERAGE(Table1[Amount]),ALL(Table1))

    Regards,