Forum Discussion

pgo's avatar
pgo
Frequent Visitor
2 years ago
Solved

Average Line on Clustered Bar Chart

Hi Guys,   I wanted to apply average lines on my chart, but, after enabling display values, it shows a different average vs the measure I created. I have a clustered bar chart with Supplier Catego...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi pgo ,

    I have tested in my environment but it seems work fine that the value in average line and median line are the same as the value in the card. Both of them have also applied same filters.

    Have you set the field in Y-axis in line chart as the same as in the card? The field count represent what and what is the data category of it? Usually, if the field is a sigma value, it should show the same value both in line chart and cards. Could you please consider provide a dummy .pbix file for further discussion?

     

     

     

    Best Regards

    Yilong Zhou

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • pgo's avatar
    pgo
    2 years ago

    Thanks for the update. As a workaround, I applied Constant Line instead of Average line.